Notice: This Wiki is now read only and edits are no longer 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
(Created page with "== Oracle 11g/12c == Default EE standalone database installation should work fine. User needs rights to execute DBMS_RLS package. CREATE USER user_name IDENTIFIED BY user_...") |
|||
Line 7: | Line 7: | ||
GRANT ALL PRIVILEGES TO user_name IDENTIFIED BY user_password; | GRANT ALL PRIVILEGES TO user_name IDENTIFIED BY user_password; | ||
GRANT EXECUTE ON DBMS_RLS TO user_name; | GRANT EXECUTE ON DBMS_RLS TO user_name; | ||
+ | GRANT EXECUTE ON DBMS_FLASHBACK TO user_name; | ||
+ | GRANT EXECUTE ON DBMS_SESSION TO user_name; |
Revision as of 11:14, 24 November 2014
Oracle 11g/12c
Default EE standalone database installation should work fine. User needs rights to execute DBMS_RLS package.
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;