oracle DBA 角色重建
一哥們由於誤操作,在pl/sql developer中直接將公司測試資料庫伺服器中DBA 角色給刪除了,導致system使用者建立普通使用者的許可權丟失,只好協助其重建,通過晚上檢視資料,過程如下:
-- Create the role
create role DBA;
-- Grant/Revoke object privileges
grant execute on DBMS_DBVERIFY to DBA;
grant execute on DBMS_DEFER_QUERY to DBA;
grant execute on DBMS_DEFER_SYS to DBA;
grant execute on DBMS_FEATURE_USAGE to DBA;
grant execute on DBMS_FLASHBACK to DBA;
grant execute on DBMS_MONITOR to DBA;
grant execute on DBMS_RESUMABLE to DBA;
grant execute on DBMS_SERVER_ALERT to DBA;
grant execute on DBMS_SERVER_TRACE to DBA;
grant execute on DBMS_SERVICE to DBA;
grant execute on DBMS_STORAGE_MAP to DBA;
grant execute on DBMS_UADV_ARR to DBA;
grant execute on DBMS_UNDO_ADV to DBA;
grant execute on DBMS_WORKLOAD_REPOSITORY to DBA;
grant execute on LOAD_UNDO_STAT to DBA;
grant select, insert, update, delete, alter on MAP_OBJECT to DBA;
grant execute on OUTLN_EDIT_PKG to DBA;
grant execute on OUTLN_PKG to DBA;
grant execute on 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 set to DBA with admin option;
grant administer database trigger to DBA with admin option;
grant administer resource manager to DBA with admin option;
grant administer sql tuning set to DBA with admin option;
grant advisor to DBA with admin option;
grant alter any cluster to DBA with admin option;
grant alter any dimension to DBA with admin option;
grant alter any evaluation context to DBA with admin option;
grant alter any index to DBA with admin option;
grant alter any indextype to DBA with admin option;
grant alter any library to DBA with admin option;
grant alter any materialized view to DBA with admin option;
grant alter any outline to DBA with admin option;
grant alter any procedure to DBA with admin option;
grant alter any role to DBA with admin option;
grant alter any rule to DBA with admin option;
grant alter any rule set to DBA with admin option;
grant alter any sequence to DBA with admin option;
grant alter any sql profile to DBA with admin option;
grant alter any table to DBA with admin option;
grant alter any trigger to DBA with admin option;
grant alter any type to DBA with admin option;
grant alter database to DBA with admin option;
grant alter profile to DBA with admin option;
grant alter resource cost to DBA with admin option;
grant alter rollback segment to DBA with admin option;
grant alter session to DBA with admin option;
grant alter system to DBA with admin option;
grant alter tablespace to DBA with admin option;
grant alter user to DBA with admin option;
grant analyze any to DBA with admin option;
grant analyze any dictionary to DBA with admin option;
grant audit any to DBA with admin option;
grant audit system to DBA with admin option;
grant backup any table to DBA with admin option;
grant become user to DBA with admin option;
grant comment any table to DBA with admin option;
grant create any cluster to DBA with admin option;
grant create any context to DBA with admin option;
grant create any dimension to DBA with admin option;
grant create any directory to DBA with admin option;
grant create any evaluation context to DBA with admin option;
grant create any index to DBA with admin option;
grant create any indextype to DBA with admin option;
grant create any job to DBA with admin option;
grant create any library to DBA with admin option;
grant create any materialized view to DBA with admin option;
grant create any operator to DBA with admin option;
grant create any outline to DBA with admin option;
grant create any procedure to DBA with admin option;
grant create any rule to DBA with admin option;
grant create any rule set to DBA with admin option;
grant create any sequence to DBA with admin option;
grant create any sql profile to DBA with admin option;
grant create any synonym to DBA with admin option;
grant create any table to DBA with admin option;
grant create any trigger to DBA with admin option;
grant create any type to DBA with admin option;
grant create any view to DBA with admin option;
grant create cluster to DBA with admin option;
grant create database link to DBA with admin option;
grant create dimension to DBA with admin option;
grant create evaluation context to DBA with admin option;
grant create indextype to DBA with admin option;
grant create job to DBA with admin option;
grant create library to DBA with admin option;
grant create materialized view to DBA with admin option;
grant create operator to DBA with admin option;
grant create procedure to DBA with admin option;
grant create profile to DBA with admin option;
grant create public database link to DBA with admin option;
grant create public synonym to DBA with admin option;
grant create role to DBA with admin option;
grant create rollback segment to DBA with admin option;
grant create rule to DBA with admin option;
grant create rule set to DBA with admin option;
grant create sequence to DBA with admin option;
grant create session to DBA with admin option;
grant create synonym to DBA with admin option;
grant create table to DBA with admin option;
grant create tablespace to DBA with admin option;
grant create trigger to DBA with admin option;
grant create type to DBA with admin option;
grant create user to DBA with admin option;
grant create view to DBA with admin option;
grant debug any procedure to DBA with admin option;
grant debug connect session to DBA with admin option;
grant delete any table to DBA with admin option;
grant dequeue any queue to DBA with admin option;
grant drop any cluster to DBA with admin option;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/30208428/viewspace-2123573/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORACLE角色(通過DBA建立)Oracle
- Oracle dba角色和sysdba的區別Oracle
- 【DBA】Oracle dba角色不是萬能的,儲存過程需要顯示授權Oracle儲存過程
- Oracle 角色 自定義角色 RoleOracle
- oracle重建ocrOracle
- oracle重建索引Oracle索引
- Oracle OEM重建Oracle
- 重建oracle EMOracle
- MySQL DBA工作角色和職責介紹MySql
- oracle重建索引(一)Oracle索引
- oracle重建索引(三)Oracle索引
- oracle重建索引(二)Oracle索引
- ORACLE RAC重建OCROracle
- oracle 重建EM databaseOracleDatabase
- oracle 4--角色Oracle
- oracle中的角色Oracle
- Oracle重建awr步驟Oracle
- Oracle重建控制檔案Oracle
- oracle批量重建索引方法Oracle索引
- oracle 重建控制檔案Oracle
- Oracle DBA 和Oracle EBS DBA 的最大區別Oracle
- 2 Day DBA-管理Oracle例項-關於管理帳戶和許可權-修改角色Oracle
- 2 Day DBA-管理Oracle例項-關於管理帳戶和許可權-建立角色Oracle
- ORACLE中的許可權/角色/DBA/SYSDBA以及remote_login_passwordfile引數的作用OracleREM
- Oracle DBA ChecklistOracle
- Oracle DBA ScriptsOracle
- Oracle DBA websitesOracleWeb
- dba-oracleOracle
- oracle 索引什麼時候重建和重建方法討論Oracle索引
- ORACLE重建OEM的步驟Oracle
- Oracle 控制檔案的重建Oracle
- oracle重建UNDO表空間Oracle
- oracle 索引重建提示指令碼Oracle索引指令碼
- ORACLE RAC重建ASM磁碟組OracleASM
- oracle 索引分析及索引重建Oracle索引
- Oracle中重建表分割槽Oracle
- 2022 DBA 角色轉換 挑戰 與 機遇
- Oracle DBA 日常管理Oracle