You created an application context successfully. The user OE was granted the EXECUTE
privilege on the DBMS_SESSION package. The user receives this error while setting the value
for an attribute within the context:
SQL> EXECUTE
DBMS_SESSION.SET_CONTEXT(‘SALES_ORDERS_CTX’,’ACCOUNT_MGR’,’OE’);
BEGIN DBMS_SESSION.SET_CONTEXT(‘SALES_ORDERS_CTX’,’ACCOUNT_MGR’,’OE’);
END;
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at “SYS.DBMS_SESSION”, line 94
ORA-06512: at line 1
What is the reason for this error?
A.
The context was created with a package name in the USING clause.
B.
The attribute can be set only in the package associated with the context.
C.
The package associated with the context did not exist at the time of creation of the context.
D.
The value for an attribute of a user-defined context can be set only by the ALTER SESSION
command.
B