Category Archives: sql

Oracle Roles

Role Related Views * Viewing Privilege and Role Information Database Roles All Database Roles SELECT * FROM DBA_ROLES; All System Privileges SELECT * FROM DBA_SYS_PRIVS; All Column-specific Privileges SELECT GRANTEE, TABLE_NAME, COLUMN_NAME, PRIVILEGE FROM DBA_COL_PRIVS; All Roles Granted to Users … Continue reading

Posted in oracle, sql | Leave a comment