This shows you the differences between two versions of the page.
— |
kurs:user_privileges [2021/10/05 13:34] (current) admin created |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | <code> | ||
+ | select * from | ||
+ | ( | ||
+ | select granted_role, grantee from dba_role_privs | ||
+ | union | ||
+ | select PRIVILEGE, GRANTEE from dba_sys_privs | ||
+ | ) | ||
+ | where grantee = 'PBADMIN'; | ||
+ | </code> | ||
+ | evtl noch sys_tab_privs integrieren |