Enterprise Manager Generic (MOSC)

MOSC Banner

match users and role

edited Jan 27, 2011 4:23AM in Enterprise Manager Generic (MOSC) 3 commentsAnswered
Hello all,

I´m trying to correlate the users and the user role. To do this, I´m querying two views: DBA_USERS to get username and status and DBA_ROLE_PRIVS to get the granted role.

In the DBA_ROLE_PRIVS I´m getting some GRANTEE (users) that not correspond with USERNAME in DBA_USERS. By example,  DBA exist in DBA_ROLE_PRIVS view, but not in DBA_USERS view.

Anyone know why is this happen?

Thank you in advance.

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