You created the SALES_ORDERS_CTX context to use the OE.SALES_ORDERS_PKG package.
View Exhibit1 and examine the package that is used with the context.
View Exhibit2 to examine the policy defined and the logon trigger.
A user receives the following error when he or she executes a query:
ERROR at line 2:
ORA-28112: failed to execute policy function
What could be the reason for the error?
A.
The user has insufficient privileges on the DBMS_SESSION package.
B.
The subprograms inside the package have not been created with the invoker’s right.
C.
The THE_PREDICATE function has an insufficient number of parameters in the package.
D.
The policy is created by using SALES_ORDERS_PKG.THE_PREDICATE without a parameter.
C
Answer c) : The policy function should accept the schema name and database object name as
input parameters. Though these parameters are not used in the function
body, the parameters are supplied by the DBMS_RLS package while creating
the policy. The sequence of parameters must be the schema name followed
by the object name.
why not D?
??