DBA Hub

📋Steps in this guide1/1

View Privileges granted to an user

-- System privileges granted to an user ( scott)

oracle configurationintermediate
by OracleDba
12 views
1

View Privileges granted to an user

-- System privileges granted to an user ( scott) -- Roles granted to an user ( scott) -- Object privileges granted to an user ( SCOTT) -- Column specific privileges granted

Code/Command (click line numbers to comment):

1
2
3
4
SELECT * FROM DBA_SYS_PRIVS where grantee='SCOTT';
SELECT * FROM DBA_ROLE_PRIVS where grantee='SCOTT';
SELECT * FROM DBA_TAB_PRIVS WHERE GRANTEE='SCOTT';
SELECT * FROM DBA_COL_PRIVS WHERE WHERE GRANTEE='SCOTT';

Comments (0)

Please to add comments

No comments yet. Be the first to comment!