Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

User roles and privilages

edited Jun 25, 2015 10:03AM in Database Install/Upgrade/Opatch (MOSC) 3 commentsAnswered

Hi All,

This maybe a silly question and I have done some google searches but not really found anything useful so far!

I have a user which has read rights to all packages/views/functions/tables etc via a SELECT role, which works perfectly fine.

For one user we want the same privileges assigned except for a specific package (called encryption) for obvious reasons so this user cannot decrypt password etc.

I basically wanted to revoke privileges on this package for this user

I tried revoking the privilege via sqlplus and get the following:

ERROR at line 1:

ORA-01927: cannot REVOKE privileges you did not grant

Tagged:

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