用户创建:
select dbms_Metadata.get_ddl( 'USER','PHIL' ) from dual;
默认角色:
select dbms_Metadata.get_granted_ddl( 'DEFAULT_ROLE','PHIL' ) from dual;
系统补助金:
select dbms_Metadata.get_granted_ddl( 'SYSTEM_GRANT','PHIL' ) from dual;
对象授予:
select dbms_Metadata.get_granted_ddl( 'OBJECT_GRANT','PHIL' ) from dual;
角色授予:
select dbms_Metadata.get_granted_ddl( 'ROLE_GRANT','PHIL' ) from dual;
配额:
select dbms_Metadata.get_granted_ddl( 'TABLESPACE_QUOTA','PHIL' ) from dual;
如果上面的任何一个没有输出,你会得到一个如下所示的异常:
sql> select dbms_Metadata.get_granted_ddl( 'TABLESPACE_QUOTA','PHIL' ) from dual;
ERROR:
ORA-31608: specified object of type TABLESPACE_QUOTA not found
ORA-06512: at "SYS.DBMS_MetaDATA",line 4018
ORA-06512: at "SYS.DBMS_MetaDATA",line 5991
ORA-06512: at line 1
no rows selected
sql>
然后在输出上进行搜索并替换以更改用户名.