set pages 0 line 132 rimspool on spool cre8roles exec dbms_metadata.set_transform_param( - dbms_metadata.session_transform, 'SQLTERMINATOR', true); -- Create the roles SELECT DBMS_METADATA.GET_DDL('ROLE', role)||';' FROM dba_roles / -- Roles which are granted to roles SELECT DBMS_METADATA.GET_GRANTED_DDL('ROLE_GRANT', role) FROM role_role_privs / -- System privileges granted to roles SELECT DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT', role) FROM ROLE_SYS_PRIVS / -- Table privileges granted to roles SELECT DBMS_METADATA.GET_GRANTED_DDL('OBJECT_GRANT', role) FROM ROLE_TAB_PRIVS / spool off
dbms_metadata role
最新推荐文章于 2022-03-30 14:33:16 发布