dbms_metadata1 dbms_metadata username = tom 1. user 생성 select dbms_metadata.get_ddl('USER','TOM') from dual; 2. user role select dbms_metadata.get_granted_ddl('ROLE_GRANT','TOM') from dual; 3. user system grant select dbms_metadata.get_granted_ddl('SYSTEM_GRANT','TOM') from dual; 4. user object grant select dbms_metadata.get_granted_ddl('OBJECT_GRANT','TOM') from dual; owner=system USER 생성 sql select 'select dbms_metadata.g.. 2010. 2. 9. 이전 1 다음