TUHRA Logo

Oracle JDeveloper 10g for Forms & PL/SQL Developers
Script
Chapter 15
Section Loading Audit Columns Using a Database Procedure and Application Context | Create the Database Objects
Code Script to grant access to SYS_CONTEXT to HR user
Return to listings...

Run the following script from SQL*Plus or a similar SQL worksheet. Connect as SYS or another DBA account connected as SYSDBA

GRANT EXECUTE ON SYS.dbms_session TO hr;
GRANT CREATE ANY CONTEXT TO hr;
GRANT DROP ANY CONTEXT TO hr;
GRANT SELECT ON SYS.v_$session TO hr;