共计 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;
感谢各位的阅读！关于“oracle DBA 如何实现角色重建”这篇文章就分享到这里了，希望以上内容可以对大家有一定的帮助，让大家可以学到更多知识，如果觉得文章不错，可以把它分享出去让更多的人看到吧！
