ORACLE 系统特权

授予系统特权:

数据库: alter database ,alter system, audit system, audit any,
调试:debug connect session,debug any procedure
索引:create any index,alter any index,drop any index,
作业调度:create job,create any job,execute any program,execute any class,manage scheduler
过程: create procedure ,create any procedure,alter any procedure,drop any procedure execute any procedure

概况:create profile,alter profile,drop profile
角色:create role,alter any role ,drop any role,grant any role
序列:create sequence ,create any sequence ,alter any sequence,drop any sequence,select any sequence

会话:create session,alter session,alter resource cost ,restricted session
同义词:create synonym,create any synonym,create public synonym
表 :create any table create table alter any table drop any table,comment any table
   drop any table,select any table,insert any table,update any table delete any table
 lock any table,flashback any table
表空间:create tablespace,alter tablespace,drop tablespace,manage tablespace begin backup end backup
触发器:create trigger create any trigger,alter any trigger,drop any trigger,administer database trigger
用户:create user,alter user,drop user
视图:create view ,create any view,drop any view,comment any table flashback any table

其他系统特权:
analyze any
grant any object privilege
grant any role
select any dictionary
sysdba
spfile
sysoper



评论暂缺

(Required)
(Required, will not be published)