oracle DBA如何实现角色重建

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

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

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

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

原创文章,作者:Maggie-Hunter,如若转载,请注明出处:https://blog.ytso.com/205339.html

(0)
上一篇 2021年11月29日
下一篇 2021年11月29日

相关推荐

发表回复

登录后才能评论