By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
SELECT privilege FROM dba_sys_privs WHERE grantee='SCOTT';To see which object privileges are granted to the user SCOTT, use the following query:
SELECT owner,table_name,privilege FROM dba_tab_privs WHERE grantee='SCOTT';To see which roles are granted to the user SCOTT, use the following query:
SELECT granted_role FROM dba_role_privs WHERE grantee='SCOTT';
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.