Oracle创建系统角色DBA

-- Create the role create role DBA; -- Grant/Revoke object privileges grant execute on SYS.DBMS_DBVERIFY to DBA; grant execute on SYS.DBMS_DEFER_QUERY to DBA; grant execute on SYS.DBMS_DEFER_SYS to DBA; grant execute on SYS.DBMS_FEATURE_USAGE to DBA; grant execute on SYS.DBMS_FLASHBACK to DBA; grant execute on SYS.DBMS_MONITOR to DBA; grant execute on SYS.DBMS_RESUMABLE to DBA; grant execute on SYS.DBMS_SERVER_ALERT to DBA; grant execute on SYS.DBMS_SERVER_TRACE to DBA; grant execute on SYS.DBMS_SERVICE to DBA; grant execute on SYS.DBMS_STORAGE_MAP to DBA; grant execute on SYS.DBMS_UADV_ARR to DBA; grant execute on SYS.DBMS_UNDO_ADV to DBA; grant execute on SYS.DBMS_WORKLOAD_REPOSITORY to DBA; grant execute on SYS.LOAD_UNDO_STAT to DBA; grant select, insert, update, delete, alter on SYS.MAP_OBJECT to DBA; grant execute on SYS.OUTLN_EDIT_PKG to DBA; grant execute on SYS.OUTLN_PKG to DBA; grant execute on SYS.RESET_UNDO_STAT to DBA; grant update on WKSYS.WK$SYS_CONFIG to DBA; -- Grant/Revoke role privileges grant delete_catalog_role to DBA with admin option; grant execute_catalog_role to DBA with admin option; grant exp_full_database to DBA; grant gather_system_statistics to DBA; grant imp_full_database to DBA; grant java_admin to DBA; grant java_deploy to DBA; grant olap_dba to DBA; grant scheduler_admin to DBA with admin option; grant select_catalog_role to DBA with admin option; grant wm_admin_role to DBA; grant xdbadmin to DBA; -- Grant/Revoke system privileges grant administer any sql tuning set to DBA with admin option; grant administer database trigger to DBA with admin option; grant administer resource manager to DBA with admin option; grant administer sql tuning set to DBA with admin option; grant advisor to DBA with admin option; grant alter any cluster to DBA with admin option; grant alter any dimension to DBA with admin option; grant alter any evaluation context to DBA with admin option; grant alter any index to DBA with admin option; grant alter any indextype to DBA with admin option; grant alter any library to DBA with admin option; grant alter any materialized view to DBA with admin option; grant alter any outline to DBA with admin option; grant alter any procedure to DBA with admin option; grant alter any role to DBA with admin option; grant alter any rule to DBA with admin option; grant alter any rule set to DBA with admin option; grant alter any sequence to DBA with admin option; grant alter any sql profile to DBA with admin option; grant alter any table to DBA with admin option; grant alter any trigger to DBA with admin option; grant alter any type to DBA with admin option; grant alter database to DBA with admin option; grant alter profile to DBA with admin option; grant alter resource cost to DBA with admin option; grant alter rollback segment to DBA with admin option; grant alter session to DBA with admin option; grant alter system to DBA with admin option; grant alter tablespace to DBA with admin option; grant alter user to DBA with admin option; grant analyze any to DBA with admin option; grant analyze any dictionary to DBA with admin option; grant audit any to DBA with admin option; grant audit system to DBA with admin option; grant backup any table to DBA with admin option; grant become user to DBA with admin option; grant comment any table to DBA with admin option; grant create any cluster to DBA with admin option; grant create any context to DBA with admin option; grant create any dimension to DBA with admin option; grant create any directory to DBA with admin option; grant create any evaluation context to DBA with admin option; grant create any index to DBA with admin option; grant create any indextype to DBA with admin option; grant create any job to DBA with admin option; grant create any library to DBA with admin option; grant create any materialized view to DBA with admin option; grant create any operator to DBA with admin option; grant create any outline to DBA with admin option; grant create any procedure to DBA with admin option; grant create any rule to DBA with admin option; grant create any rule set to DBA with admin option; grant create any sequence to DBA with admin option; grant create any sql profile to DBA with admin option; grant create any synonym to DBA with admin option; grant create any table to DBA with admin option; grant create any trigger to DBA with admin option; grant create any type to DBA with admin option; grant create any view to DBA with admin option; grant create cluster to DBA with admin option; grant create database link to DBA with admin option; grant create dimension to DBA with admin option; grant create evaluation context to DBA with admin option; grant create indextype to DBA with admin option; grant create job to DBA with admin option; grant create library to DBA with admin option; grant create materialized view to DBA with admin option; grant create operator to DBA with admin option; grant create procedure to DBA with admin option; grant create profile to DBA with admin option; grant create public database link to DBA with admin option; grant create public synonym to DBA with admin option; grant create role to DBA with admin option; grant create rollback segment to DBA with admin option; grant create rule to DBA with admin option; grant create rule set to DBA with admin option; grant create sequence to DBA with admin option; grant create session to DBA with admin option; grant create synonym to DBA with admin option; grant create table to DBA with admin option; grant create tablespace to DBA with admin option; grant create trigger to DBA with admin option; grant create type to DBA with admin option; grant create user to DBA with admin option; grant create view to DBA with admin option; grant debug any procedure to DBA with admin option; grant debug connect session to DBA with admin option; grant delete any table to DBA with admin option; grant dequeue any queue to DBA with admin option; grant drop any cluster to DBA with admin option; grant drop any context to DBA with admin option; grant drop any dimension to DBA with admin option; grant drop any directory to DBA with admin option; grant drop any evaluation context to DBA with admin option; grant drop any index to DBA with admin option; grant drop any indextype to DBA with admin option; grant drop any library to DBA with admin option; grant drop any materialized view to DBA with admin option; grant drop any operator to DBA with admin option; grant drop any outline to DBA with admin option; grant drop any procedure to DBA with admin option; grant drop any role to DBA with admin option; grant drop any rule to DBA with admin option; grant drop any rule set to DBA with admin option; grant drop any sequence to DBA with admin option; grant drop any sql profile to DBA with admin option; grant drop any synonym to DBA with admin option; grant drop any table to DBA with admin option; grant drop any trigger to DBA with admin option; grant drop any type to DBA with admin option; grant drop any view to DBA with admin option; grant drop profile to DBA with admin option; grant drop public database link to DBA with admin option; grant drop public synonym to DBA with admin option; grant drop rollback segment to DBA with admin option; grant drop tablespace to DBA with admin option; grant drop user to DBA with admin option; grant enqueue any queue to DBA with admin option; grant execute any class to DBA with admin option; grant execute any evaluation context to DBA with admin option; grant execute any indextype to DBA with admin option; grant execute any library to DBA with admin option; grant execute any operator to DBA with admin option; grant execute any procedure to DBA with admin option; grant execute any program to DBA with admin option; grant execute any rule to DBA with admin opti