Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- VALABLE UNIQUEMENT sous Oracle
- -- Roles :
- SELECT PRIVILEGE
- FROM sys.dba_sys_privs
- WHERE grantee = <theUser>
- UNION
- SELECT PRIVILEGE
- FROM dba_role_privs rp JOIN role_sys_privs rsp ON (rp.granted_role = rsp.role)
- WHERE rp.grantee = <theUser>
- ORDER BY 1;
- -- Drotits directs :
- SELECT owner, table_name, select_priv, insert_priv, delete_priv, update_priv, references_priv, alter_priv, index_priv
- FROM table_privileges
- WHERE grantee = <theUser>
- ORDER BY owner, table_name;
- -- Droits par roles :
- SELECT DISTINCT owner, table_name, PRIVILEGE
- FROM dba_role_privs rp JOIN role_tab_privs rtp ON (rp.granted_role = rtp.role)
- WHERE rp.grantee = <theUser>
- ORDER BY owner, table_name;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement