oracle DBA如何实现角色重建

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

由于误操作，在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如何实现角色重建”这篇文章就分享到这里了，希望以上内容可以对大家有一定的帮助，让大家可以学到更多知识，如果觉得文章不错，可以把它分享出去让更多的人看到吧！