select dbms_metadata.get_granted_ddl( 'SYSTEM_GRANT', 'N_HSE' ) from dual;
select dbms_metadata.get_granted_ddl( 'OBJECT_GRANT', 'N_HSE' ) from dual;
select dbms_metadata.get_granted_ddl( 'ROLE_GRANT', 'N_HSE') from dual;

SELECT * FROM USER_SYS_PRIVS; 
SELECT * FROM USER_TAB_PRIVS;
SELECT * FROM USER_ROLE_PRIVS;

پسندها(0)شاکی(0)