DBA解决被人干掉了,恢复方式。 -- Create the role create role DBA; -- Grant/Revoke object privileges grant execute on SYS.DBMS_DEFER_QUERY to DBA; grant execute on SYS.DBMS_DEFER_SYS to DBA; grant execute on SYS.DBMS_FLASHBACK to DBA; grant execute on SYS.DBMS_RESUMABLE to DBA; grant execute on SYS.JIS_EXP to DBA; grant execute on SYS.JIS_IMP_AUX to DBA; grant execute on SYS.LT_EXPADM_PKG to DBA; grant execute on SYS.LT_EXPORT_PKG to DBA; grant execute on SYS.OUTLN_EDIT_PKG to DBA; grant execute on SYS.OUTLN_PKG 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 imp_full_database to DBA; grant java_admin to DBA; grant java_deploy to DBA; grant olap_dba to DBA; grant select_catalog_role to DBA with admin option; grant wm_admin_role to DBA; -- Grant/Revoke system privileges grant administer database trigger to DBA with admin option; grant administer resource manager to DBA with admin option; grant administer security 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 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 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 security profile to DBA with admin option; grant alter any sequence to DBA with admin option; grant alter any snapshot 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 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 index to DBA with admin option; grant create any indextype to DBA with admin option; grant create any library 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 security profile to DBA with admin option; grant create any sequence to DBA with admin option; grant create any snapshot 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 indextype to DBA with admin option; grant create library 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 security profile to DBA with admin option; grant create sequence to DBA with admin option; grant create session to DBA with admin option; grant create snapshot 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 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; grant drop any context to DBA with admin option; grant drop any dimension to DBA with admin option; grant drop any directory to DBA with admin option; grant drop any index to DBA with admin option; grant drop any indextype to DBA with admin option; grant drop any library to DBA with admin option; grant drop any operator to DBA with admin option; grant drop any outline to DBA with admin option; grant drop any procedure to DBA with admin option; grant drop any role to DBA with admin option; grant drop any sequence to DBA with admin option; grant drop any snapshot to DBA with admin option; grant drop any synonym to DBA with admin option; grant drop any table to DBA with admin option; grant drop any trigger to DBA with admin option; grant drop any type to DBA with admin option; grant drop any view to DBA with admin option; grant drop profile to DBA with admin option; grant drop public database link to DBA with admin option; grant drop public synonym to DBA with admin option; grant drop rollback segment to DBA with admin option; grant drop tablespace to DBA with admin option; grant drop user to DBA with admin option; grant enqueue any queue to DBA with admin option; grant execute any indextype to DBA with admin option; grant execute any library to DBA with admin option; grant execute any operator to DBA with admin option; grant execute any procedure to DBA with admin option; grant execute any type to DBA with admin option; grant force any transaction to DBA with admin option; grant force transaction to DBA with admin option; grant global query rewrite to DBA with admin option; grant grant any privilege to DBA with admin option; grant grant any role to DBA with admin option; grant insert any table to DBA with admin option; grant lock any table to DBA with admin option; grant manage any queue to DBA with admin option; grant manage tablespace to DBA with admin option; grant on commit refresh to DBA with admin option; grant query rewrite to DBA with admin option; grant restricted session to DBA with admin option; grant resumable to DBA with admin option; grant select any dictionary to DBA with admin option; grant select any sequence to DBA with admin option; grant select any table to DBA with admin option; grant under any table to DBA with admin option; grant under any type to DBA with admin option; grant under any view to DBA with admin option; grant update any table to DBA with admin option;
-- Create the role
create role DBA;
-- Grant/Revoke object privileges
grant execute on SYS.DBMS_DEFER_QUERY to DBA;
grant execute on SYS.DBMS_DEFER_SYS to DBA;
grant execute on SYS.DBMS_FLASHBACK to DBA;
grant execute on SYS.DBMS_RESUMABLE to DBA;
grant execute on SYS.JIS_EXP to DBA;
grant execute on SYS.JIS_IMP_AUX to DBA;
grant execute on SYS.LT_EXPADM_PKG to DBA;
grant execute on SYS.LT_EXPORT_PKG to DBA;
grant execute on SYS.OUTLN_EDIT_PKG to DBA;
grant execute on SYS.OUTLN_PKG 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 imp_full_database to DBA;
grant java_admin to DBA;
grant java_deploy to DBA;
grant olap_dba to DBA;
grant select_catalog_role to DBA with admin option;
grant wm_admin_role to DBA;
-- Grant/Revoke system privileges
grant administer database trigger to DBA with admin option;
grant administer resource manager to DBA with admin option;
grant administer security 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 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 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 security profile to DBA with admin option;
grant alter any sequence to DBA with admin option;
grant alter any snapshot 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 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 index to DBA with admin option;
grant create any indextype to DBA with admin option;
grant create any library 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 security profile to DBA with admin option;
grant create any sequence to DBA with admin option;
grant create any snapshot 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 indextype to DBA with admin option;
grant create library 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 security profile to DBA with admin option;
grant create sequence to DBA with admin option;
grant create session to DBA with admin option;
grant create snapshot 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 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;
grant drop any context to DBA with admin option;
grant drop any dimension to DBA with admin option;
grant drop any directory to DBA with admin option;
grant drop any index to DBA with admin option;
grant drop any indextype to DBA with admin option;
grant drop any library to DBA with admin option;
grant drop any operator to DBA with admin option;
grant drop any outline to DBA with admin option;
grant drop any procedure to DBA with admin option;
grant drop any role to DBA with admin option;
grant drop any sequence to DBA with admin option;
grant drop any snapshot to DBA with admin option;
grant drop any synonym to DBA with admin option;
grant drop any table to DBA with admin option;
grant drop any trigger to DBA with admin option;
grant drop any type to DBA with admin option;
grant drop any view to DBA with admin option;
grant drop profile to DBA with admin option;
grant drop public database link to DBA with admin option;
grant drop public synonym to DBA with admin option;
grant drop rollback segment to DBA with admin option;
grant drop tablespace to DBA with admin option;
grant drop user to DBA with admin option;
grant enqueue any queue to DBA with admin option;
grant execute any indextype to DBA with admin option;
grant execute any library to DBA with admin option;
grant execute any operator to DBA with admin option;
grant execute any procedure to DBA with admin option;
grant execute any type to DBA with admin option;
grant force any transaction to DBA with admin option;
grant force transaction to DBA with admin option;
grant global query rewrite to DBA with admin option;
grant grant any privilege to DBA with admin option;
grant grant any role to DBA with admin option;
grant insert any table to DBA with admin option;
grant lock any table to DBA with admin option;
grant manage any queue to DBA with admin option;
grant manage tablespace to DBA with admin option;
grant on commit refresh to DBA with admin option;
grant query rewrite to DBA with admin option;
grant restricted session to DBA with admin option;
grant resumable to DBA with admin option;
grant select any dictionary to DBA with admin option;
grant select any sequence to DBA with admin option;
grant select any table to DBA with admin option;
grant under any table to DBA with admin option;
grant under any type to DBA with admin option;
grant under any view to DBA with admin option;
grant update any table to DBA with admin option;