Exadata General (MOSC)

MOSC Banner

What privileges do you need to give a user so they can execute sys.dbms_compression procs?

edited Mar 6, 2016 4:00AM in Exadata General (MOSC) 3 commentsAnswered

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!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center