What privileges do I need in order to grant execute on dbms_rls?
Which privileges does that user require in order to grant execute on dbms_rls?


The grating user should have the execute privilege on DBMS_RLS with GRANT OPTION. 

I have two users namely usra and usrb. I have granted execute on DBMS_RLS to usra with admin option. Then usra is able to grant the privilege to usrb.

SQL&gt; conn / as sysdba
SQL&gt; grant execute on dbms_rls to usra with grant option;

Grant succeeded.

SQL&gt; conn usra/usra
Connected.
SQL&gt; grant execute on sys.dbms_rls to usrb;

Grant succeeded.