oracle DBA 角色重建

最新推荐文章于 2021-04-13 23:52:05 发布

cplj45920

最新推荐文章于 2021-04-13 23:52:05 发布

阅读量202

点赞数

文章标签：数据库

一哥们由于误操作，在pl/sql developer中直接将公司测试数据库服务器中DBA 角色给删除了，导致system用户建立普通用户的权限丢失，只好协助其重建，通过晚上查看资料，过程如下：

-- Create the role
create role DBA;
-- Grant/Revoke object privileges
grant execute on DBMS_DBVERIFY to DBA;
grant execute on DBMS_DEFER_QUERY to DBA;
grant execute on DBMS_DEFER_SYS to DBA;
grant execute on DBMS_FEATURE_USAGE to DBA;
grant execute on DBMS_FLASHBACK to DBA;
grant execute on DBMS_MONITOR to DBA;
grant execute on DBMS_RESUMABLE to DBA;
grant execute on DBMS_SERVER_ALERT to DBA;
grant execute on DBMS_SERVER_TRACE to DBA;
grant execute on DBMS_SERVICE to DBA;
grant execute on DBMS_STORAGE_MAP to DBA;
grant execute on DBMS_UADV_ARR to DBA;
grant execute on DBMS_UNDO_ADV to DBA;
grant execute on DBMS_WORKLOAD_REPOSITORY to DBA;
grant execute on LOAD_UNDO_STAT to DBA;
grant select, insert, update, delete, alter on MAP_OBJECT to DBA;
grant execute on OUTLN_EDIT_PKG to DBA;
grant execute on OUTLN_PKG to DBA;
grant execute on RESET_UNDO_STAT 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;