ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEDA79D2E0530100007F1FF2 DBA Username Y select du.username value, null description from dba_users du order by du.username US DD887A70F0104B209EB103936BE0BFC4 select x.grantee, x.privilege_type, x.privilege, x.privilege_source, x.object_owner, x.object_type, x.object_name, x.grantor, x.grantable, x.hierarchy from ( select :grantee grantee, 'Object' privilege_type, dtp.privilege, case when dtp.grantee=:grantee then 'Direct' else dtp.grantee end privilege_source, dtp.owner object_owner, dtp.type object_type, dtp.table_name object_name, dtp.grantor, dtp.grantable, dtp.hierarchy from ( select :grantee grantee_ from dual union all select drp.granted_role from dba_role_privs drp start with drp.grantee=:grantee connect by drp.grantee=prior drp.granted_role ) rh, dba_tab_privs dtp where rh.grantee_=dtp.grantee and 1=1 union all select :grantee grantee, 'System' privilege_type, dsp.privilege, case when dsp.grantee=:grantee then 'Direct' else dsp.grantee end privilege_source, null object_owner, null object_type, null object_name, null grantor, dsp.admin_option grantable, null hierarchy from ( select :grantee grantee_ from dual union all select drp.granted_role from dba_role_privs drp start with drp.grantee=:grantee connect by drp.grantee=prior drp.granted_role ) rh, dba_sys_privs dsp where rh.grantee_=dsp.grantee union all select :grantee grantee, 'Role' privilege_type, drp.granted_role privilege, case when drp.grantee=:grantee then 'Direct' else drp.grantee end privilege_source, null object_owner, null object_type, null object_name, null grantor, drp.admin_option grantable, null hierarchy from ( select :grantee grantee_ from dual union all select drp2.granted_role from dba_role_privs drp2 start with drp2.grantee=:grantee connect by drp2.grantee=prior drp2.granted_role ) rh, dba_role_privs drp where rh.grantee_=drp.grantee ) x where 2=2 order by x.privilege_type, x.privilege_source, x.object_owner, x.object_type, x.object_name, x.privilege Y US DBA Object Access Privileges Database object privileges for a specific user, including privileges inherited through role grants. Useful for DB access security audits to understand exactly what objects a user can access and how the access was granted (directly or through which role chain). Enginatics 1=1 2=2 :grantee 1 10 :grantee LOV DBA Username 8E2FF36EDEDA79D2E0530100007F1FF2 Y select du.username value, null description from dba_users du order by du.username select user from dual Y US Grantee 2 20 2=2 x.privilege_type=:privilege_type LOV custom Y select 'Object' value, null description from dual union all select 'Role' value, null description from dual union all select 'System' value, null description from dual US Privilege Type 3 30 1=1 dtp.owner=:object_owner LOV DBA Username 8E2FF36EDEDA79D2E0530100007F1FF2 Y select du.username value, null description from dba_users du order by du.username US Object Owner 4 40 2=2 x.object_type=:object_type LOV custom Y select distinct do.object_type value, null description from dba_objects do where do.object_type in ('FUNCTION','PACKAGE','PROCEDURE','SEQUENCE','TABLE','TYPE','VIEW','SYNONYM','MATERIALIZED VIEW','DIRECTORY','LIBRARY','JAVA CLASS') order by do.object_type US Object Type 5 50 2=2 x.privilege=:privilege LOV custom Y select distinct dtpe.privilege value, null description from dba_tab_privs dtpe order by dtpe.privilege US Privilege