Database Security Products (MOSC)

MOSC Banner

Default role vs, non-default role

edited Apr 29, 2013 10:14PM in Database Security Products (MOSC) 7 commentsAnswered ✓
I have two users, user1, and user 2 and both users have been granter ROLE1 and ROLE2. The only difference is that for user1 both ROLE1 and ROLE2 are default roles, and for user2 only ROLE2 as a default role. User2 reports that he cannot see some of the tables he can see when loged in as User1. Could that be because ROLE1 is not a default role for user2? Can someone explain the difference to me?

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