Connect Database and Execute with user DBA privilege Put username in uppercase References NOTE:207859.1 – Object types for DBMS_METADATANOTE:1460969.1 – How To Retrieve The Full Object Definition (DDL) From The DatabaseNOTE:1163383.1 – The dbms_metadata.get_granted_ddl Does Not Extract all System Privileges
How to extract DDL for User including Privileges and Roles using dbms_metadata.get_ddl
Publicado em