Role tables

[fatcodeguy]

Hi,

does anyone know what the difference between the dba_role_privs & user_role_privs tables (or views, not sure which). I'm tempted to say one's for DBAs and the other for other users but there are entries for the same users in both tables. Thanks

 

[sem]

The difference is the same as with other dba|user views: USER_ views contain information about the user currently connected while DBA_ - about all users.

Regards, Dima