oracle DBA如何實現角色重建

146次閱讀

共計 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;