11.5.2.1 Ensuring Execute Privilege on DBMS_RLS

To use row-level data security, your workspace's parsing schema requires the EXECUTE privilege on the DBMS_RLS package.

It contains the procedures to manage data security policies. Run the following query to check if you already have the privilege to access this package:

SELECT 'DBMS_RLS accessible' as result
FROM dual
WHERE EXISTS (
    SELECT 1 FROM all_objects 
    WHERE object_name = 'DBMS_RLS' 
    AND object_type = 'PACKAGE'
    AND owner = 'SYS')

If the result is No Rows Found, then ask your DBA to run the following grant statement:

grant execute on dbms_rls to your_workspace_schema