****************************************************************************
* 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