roles – Rodrigo Silva e Silva

Extrair DDL ROLES

set heading off;
set echo off;
set pages 1000
set long 3000
spool extrair_roles_ddl.sql
select dbms_metadata.get_ddl('ROLE', ROLE) from dba_roles;
spool off



CREATE ROLE "CONNECT";

CREATE ROLE "RESOURCE";

CREATE ROLE "DBA";

CREATE ROLE "PDB_DBA";

CREATE ROLE "AUDIT_ADMIN";

CREATE ROLE "AUDIT_VIEWER";

CREATE ROLE "SELECT_CATALOG_ROLE";

set heading off;

set echo off;

set pages 1000

set long 3000

spool extrair_roles_ddl.sql

select dbms_metadata.get_ddl('ROLE', ROLE) from dba_roles;

spool off

CREATE ROLE "CONNECT";

CREATE ROLE "RESOURCE";

CREATE ROLE "DBA";

CREATE ROLE "PDB_DBA";

CREATE ROLE "AUDIT_ADMIN";

CREATE ROLE "AUDIT_VIEWER";

CREATE ROLE "SELECT_CATALOG_ROLE";

Tag: roles

Extrair DDL roles