Database Administration (MOSC)

MOSC Banner

I can`t to tune access to dictionary tables through the roles

edited Nov 28, 2014 10:03AM in Database Administration (MOSC) 2 commentsAnswered

My question is simple. After I grant access to dba_triggers as "grant select on dba_triggers to USER". User able to do "select * from dba_triggers"

But when I create role(select_dba). Grant to role select priv("grant select on dba_triggers to select_dba"). Then grant this role to user (grant select_dba to USER). After these operations user can`t to do "select * from dba_triggers".

Why?? I tried to alter this role as default.

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