Database Security Products (MOSC)

MOSC Banner

default user privileges

edited Oct 7, 2009 11:52PM in Database Security Products (MOSC) 5 commentsAnswered
 I have created a user and a role. I granted the select permission of about 6 tables in a schema to the role and than granted the role to the user. However, somehow the user is able to access some of tables in other schema as well as system tables such as sys.audit_action etc. Since I all I did was assign user the default profile, grant create session, and grant the role, I am kind of wondering if by default the user gets to access the system table?

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