查看用户建立详细原语句

select dbms_metadata.get_ddl('USER','VGOPETL') "Create_User_DDL"

from dual;

 

select dbms_metadata.get_granted_ddl('SYSTEM_GRANT','VGOPETL') "Grant dba_sys_privs DDL" from dual;

-- dba_sys_privs

select dbms_metadata.get_granted_ddl('ROLE_GRANT','VGOPETL') "Grant dba_sys_privs DDL" from dual;

-- dba_role_privs

-----------------------------------------------------------------------------------------------------------上下一样的

select dbms_metadata.get_ddl('USER','VGOPETL') "Create_User_DDL"

from dual;

 

select 'grant '||PRIVILEGE||' to '||GRANTEE||

decode(ADMIN_OPTION,'NO',';','YES',' with admin option;')

"Grant dba_sys_privs DDL"

from dba_sys_privs where grantee='VGOPETL';

 

select 'grant '||GRANTED_ROLE||' to '||GRANTEE||

decode(ADMIN_OPTION,'NO',';','YES',' with admin option;')

"Grant dba_sys_privs DDL"

from dba_role_privs where grantee='VGOPETL';