Une piste:
* USER_TAB_PRIVS grants on objects for which the user is the owner, grantor or grantee
* USER_COL_PRIVS grants on columns for which the user is the owner, grantor or grantee
* USER_SYS_PRIVS System privileges granted to current user
* USER_ROLE_PRIVS Roles granted to current user
* DBA_ROLES Lists all roles that exist in the database
* ROLE_TAB_PRIVS , ROLE_SYS_PRIVS , ROLE_ROLE_PRIVS privileges and roles granted to roles (information is provided only about roles to which the user has access).
select * from USER_ROLE_PRIVS
Partager