Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Difference between revisions of "EclipseLink/Development/Testing/Databases"
< EclipseLink | Development | Testing
Line 1: | Line 1: | ||
== Oracle 11g/12c == | == Oracle 11g/12c == | ||
− | Default EE standalone database installation should work fine. User needs rights to execute DBMS_RLS, | + | Default EE standalone database installation should work fine. |
+ | * User needs rights to execute DBMS_RLS, DBMS_FLASHBACK and DBMS_SESSION packages. | ||
+ | * Database character set should be AL32UTF8. | ||
CREATE USER user_name IDENTIFIED BY user_password; | CREATE USER user_name IDENTIFIED BY user_password; |
Revision as of 12:23, 24 November 2014
Oracle 11g/12c
Default EE standalone database installation should work fine.
- User needs rights to execute DBMS_RLS, DBMS_FLASHBACK and DBMS_SESSION packages.
- Database character set should be AL32UTF8.
CREATE USER user_name IDENTIFIED BY user_password; GRANT CONNECT, RESOURCE TO user_name; GRANT ALL PRIVILEGES TO user_name IDENTIFIED BY user_password; GRANT EXECUTE ON DBMS_RLS TO user_name; GRANT EXECUTE ON DBMS_FLASHBACK TO user_name; GRANT EXECUTE ON DBMS_SESSION TO user_name;