**************************************************************************** * Description: Knowledge of queryng Oracle user system and object privilege * Date: 04:56 AM EST, 08/31/2017 **************************************************************************** <1> Query to check object privilege of a role: | |__ SQL> select grantee, owner, table_name, privilege from dba_tab_privs where grantee in ('TCLREADONLY', 'TCLDASHBOARD', 'KGTREADONLY') order by 1,2; GRANTEE OWNER TABLE_NAME PRIVILEGE --------------------- ------------------------------ ------------------------------ ---------------- KGTREADONLY BPT GLSEGMENT SELECT KGTREADONLY ERIKSYSCORE USERS SELECT KGTREADONLY ERIKSYSCORE CONVERTBLOBTOCLOB EXECUTE TCLDASHBOARD LSL LBS_HISTORY_SCRIPT SELECT TCLDASHBOARD RBSAPPCORE AUDITLOGDETAILS SELECT TCLDASHBOARD SYS V_$STATNAME SELECT TCLREADONLY ERIKSYSCORE GETFROMXPATH EXECUTE TCLREADONLY RBSAPPCORE VALIDATEMODEL EXECUTE TCLREADONLY SYS V_$STATNAME SELECT <2> Query to check system privilege of a role: | |__ SQL> select grantee, privilege from dba_sys_privs where grantee in ('TCLREADONLY', 'TCLDASHBOARD', 'KGTREADONLY') order by 1,2; GRANTEE PRIVILEGE -------------------- -------------------- KGTREADONLY SELECT ANY TABLE TCLREADONLY SELECT ANY TABLE
Your Comments