Database Security Products (MOSC)

MOSC Banner

Question about user_sys_privs

edited Oct 8, 2009 6:53PM in Database Security Products (MOSC) 6 commentsAnswered
 I have a customer who is granting priveleges to a schema.  He then queries user_sys_privs but the table is blank and the schema has no priveleges still.  Shouldn't the priveleges show up in user_sys_privs ?

SQL> grant select any table to am_agent;

Grant succeeded.

SQL> select * from user_sys_privs where username = 'AM_AGENT';

no rows selected

SQL> show user
USER is "SYSTEM"

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