Command to find the DDL of Schema's:
select dbms_metadata.get_ddl( 'USER','username' ) from dual
UNION ALL
select dbms_metadata.get_granted_ddl('SYSTEM_GRANT','username') from dual
UNION ALL
select dbms_metadata.get_granted_ddl('OBJECT_GRANT','username') from dual
UNION ALL
select dbms_metadata.get_granted_ddl('ROLE_GRANT','username') from dual;
select dbms_metadata.get_ddl( 'USER','username' ) from dual
UNION ALL
select dbms_metadata.get_granted_ddl('SYSTEM_GRANT','username') from dual
UNION ALL
select dbms_metadata.get_granted_ddl('OBJECT_GRANT','username') from dual
UNION ALL
select dbms_metadata.get_granted_ddl('ROLE_GRANT','username') from dual;
No comments:
Post a Comment