oracle DBA如何实现角色重建

130次阅读

共计 5169 个字符，预计需要花费 13 分钟才能阅读完成。

这篇文章给大家分享的是有关 oracle DBA 如何实现角色重建的内容。丸趣 TV 小编觉得挺实用的，因此分享给大家做个参考，一起跟随丸趣 TV 小编过来看看吧。

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

— Create the role
create role DBA;
— Grant/Revoke object privileges
grantexecuteon DBMS_DBVERIFY to DBA;
grantexecuteon DBMS_DEFER_QUERY to DBA;
grantexecuteon DBMS_DEFER_SYS to DBA;
grantexecuteon DBMS_FEATURE_USAGE to DBA;
grantexecuteon DBMS_FLASHBACK to DBA;
grantexecuteon DBMS_MONITOR to DBA;
grantexecuteon DBMS_RESUMABLE to DBA;
grantexecuteon DBMS_SERVER_ALERT to DBA;
grantexecuteon DBMS_SERVER_TRACE to DBA;
grantexecuteon DBMS_SERVICE to DBA;
grantexecuteon DBMS_STORAGE_MAP to DBA;
grantexecuteon DBMS_UADV_ARR to DBA;
grantexecuteon DBMS_UNDO_ADV to DBA;
grantexecuteon DBMS_WORKLOAD_REPOSITORY to DBA;
grantexecuteon LOAD_UNDO_STAT to DBA;
grantselect, insert, update, delete, alteron MAP_OBJECT to DBA;
grantexecuteon OUTLN_EDIT_PKG to DBA;
grantexecuteon OUTLN_PKG to DBA;
grantexecuteon 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 setto DBA with admin option;
grant administer databasetriggerto DBA with admin option;
grant administer resource manager to DBA with admin option;
grant administer sql tuning setto DBA with admin option;
grant advisor to DBA with admin option;
grantalterany cluster to DBA with admin option;
grantalterany dimension to DBA with admin option;
grantalterany evaluation context to DBA with admin option;
grantalteranyindexto DBA with admin option;
grantalterany indextype to DBA with admin option;
grantalterany library to DBA with admin option;
grantalterany materialized viewto DBA with admin option;
grantalterany outline to DBA with admin option;
grantalteranyprocedureto DBA with admin option;
grantalterany role to DBA with admin option;
grantalteranyruleto DBA with admin option;
grantalteranyrulesetto DBA with admin option;
grantalterany sequence to DBA with admin option;
grantalterany sql profile to DBA with admin option;
grantalteranytableto DBA with admin option;
grantalteranytriggerto DBA with admin option;
grantalterany type to DBA with admin option;
grantalterdatabaseto DBA with admin option;
grantalter profile to DBA with admin option;
grantalter resource cost to DBA with admin option;
grantalterrollback segment to DBA with admin option;
grantalter session to DBA with admin option;
grantalter system to DBA with admin option;
grantalter tablespace to DBA with admin option;
grantalteruserto DBA with admin option;
grant analyze anyto DBA with admin option;
grant analyze any dictionary to DBA with admin option;
grant audit anyto DBA with admin option;
grant audit system to DBA with admin option;
grantbackupanytableto DBA with admin option;
grant become userto DBA with admin option;
grant comment anytableto DBA with admin option;
grantcreateany cluster to DBA with admin option;
grantcreateany context to DBA with admin option;
grantcreateany dimension to DBA with admin option;
grantcreateany directory to DBA with admin option;
grantcreateany evaluation context to DBA with admin option;
grantcreateanyindexto DBA with admin option;
grantcreateany indextype to DBA with admin option;
grantcreateany job to DBA with admin option;
grantcreateany library to DBA with admin option;
grantcreateany materialized viewto DBA with admin option;
grantcreateany operator to DBA with admin option;
grantcreateany outline to DBA with admin option;
grantcreateanyprocedureto DBA with admin option;
grantcreateanyruleto DBA with admin option;
grantcreateanyrulesetto DBA with admin option;
grantcreateany sequence to DBA with admin option;
grantcreateany sql profile to DBA with admin option;
grantcreateany synonym to DBA with admin option;
grantcreateanytableto DBA with admin option;
grantcreateanytriggerto DBA with admin option;
grantcreateany type to DBA with admin option;
grantcreateanyviewto DBA with admin option;
grantcreate cluster to DBA with admin option;
grantcreatedatabase link to DBA with admin option;
grantcreate dimension to DBA with admin option;
grantcreate evaluation context to DBA with admin option;
grantcreate indextype to DBA with admin option;
grantcreate job to DBA with admin option;
grantcreate library to DBA with admin option;
grantcreate materialized viewto DBA with admin option;
grantcreate operator to DBA with admin option;
grantcreateprocedureto DBA with admin option;
grantcreate profile to DBA with admin option;
grantcreatepublicdatabase link to DBA with admin option;
grantcreatepublic synonym to DBA with admin option;
grantcreate role to DBA with admin option;
grantcreaterollback segment to DBA with admin option;
grantcreateruleto DBA with admin option;
grantcreaterulesetto DBA with admin option;
grantcreate sequence to DBA with admin option;
grantcreate session to DBA with admin option;
grantcreate synonym to DBA with admin option;
grantcreatetableto DBA with admin option;
grantcreate tablespace to DBA with admin option;
grantcreatetriggerto DBA with admin option;
grantcreate type to DBA with admin option;
grantcreateuserto DBA with admin option;
grantcreateviewto DBA with admin option;
grant debug anyprocedureto DBA with admin option;
grant debug connect session to DBA with admin option;
grantdeleteanytableto DBA with admin option;
grant dequeue any queue to DBA with admin option;
grantdropany cluster to DBA with admin option;