文章详情

短信预约-IT技能 免费直播动态提醒

请输入下面的图形验证码

提交验证

短信预约提醒成功

oracle DBA如何实现角色重建

2024-04-02 19:55

关注

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

阅读原文内容投诉

免责声明:

① 本站未注明“稿件来源”的信息均来自网络整理。其文字、图片和音视频稿件的所属权归原作者所有。本站收集整理出于非商业性的教育和科研之目的,并不意味着本站赞同其观点或证实其内容的真实性。仅作为临时的测试数据,供内部测试之用。本站并未授权任何人以任何方式主动获取本站任何信息。

② 本站未注明“稿件来源”的临时测试数据将在测试完成后最终做删除处理。有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341

软考中级精品资料免费领

  • 历年真题答案解析
  • 备考技巧名师总结
  • 高频考点精准押题
  • 2024年上半年信息系统项目管理师第二批次真题及答案解析(完整版)

    难度     813人已做
    查看
  • 【考后总结】2024年5月26日信息系统项目管理师第2批次考情分析

    难度     354人已做
    查看
  • 【考后总结】2024年5月25日信息系统项目管理师第1批次考情分析

    难度     318人已做
    查看
  • 2024年上半年软考高项第一、二批次真题考点汇总(完整版)

    难度     435人已做
    查看
  • 2024年上半年系统架构设计师考试综合知识真题

    难度     224人已做
    查看

相关文章

发现更多好内容

猜你喜欢

AI推送时光机
位置:首页-资讯-数据库
咦!没有更多了?去看看其它编程学习网 内容吧
首页课程
资料下载
问答资讯