How to check the status of any Database role? Using which data dictionary table?
Thanks in advance
I'm unclear what you mean by the "status" of the role, but dba_roles, dba_role_privs, dba_application_roles might be worth looking at.
"The Oracle Sponge"
Senior Manager, Business Intelligence Development
XM Satellite Radio