oracleDBA如何实现角色重建
这篇文章给大家分享的是有关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如何实现角色重建”这篇文章就分享到这里了,希望以上内容可以对大家有一定的帮助,让大家可以学到更多知识,如果觉得文章不错,可以把它分享出去让更多的人看到吧!
网站名称:oracleDBA如何实现角色重建
分享路径:http://scyanting.com/article/geocpe.html