What privileges do you need to give a user so they can execute sys.dbms_compression procs?
What privileges do you need to give a user so they can execute sys.dbms_compression procs?
I have given execute on sys.dbms_compression to the user, but it's still getting the following error:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_ROWID", line 142
ORA-06512: at "SYS.DBMS_COMPRESSION", line 246
When I give DBA privs it works, but I want to avoid that.
Thanks!