Oracle中的所有权限

grant alter system to zys; 
grant audit system to zys;


grant create session to zys; 
grant alter session to zys; 
grant restricted session to zys; 
grant debug connect session to zys;


grant create tablespace to zys; 
grant alter tablespace to zys; 
grant manage tablespace to zys; 
grant drop tablespace to zys; 
grant unlimited tablespace to zys;


grant create user to zys; 
grant become user to zys; 
grant alter user to zys; 
grant drop user to zys;


grant create rollback segment to zys; 
grant alter rollback segment to zys; 
grant drop rollback segment to zys;


grant create table to zys; 
grant create any table to zys; 
grant alter any table to zys; 
grant backup any table to zys; 
grant drop any table to zys; 
grant lock any table to zys; 
grant comment any table to zys; 
grant select any table to zys; 
grant insert any table to zys; 
grant update any table to zys; 
grant delete any table to zys; 
grant under any table to zys; 
grant flashback any table to zys;


grant create cluster to zys; 
grant create any cluster to zys; 
grant alter any cluster to zys; 
grant drop any cluster to zys;


grant create any index to zys; 
grant alter any index to zys; 
grant drop any index to zys;


grant create synonym to zys; 
grant create any synonym to zys; 
grant drop any synonym to zys; 
grant create public synonym to zys; 
grant drop public synonym to zys;


grant create view to zys; 
grant create any view to zys; 
grant drop any view to zys; 
grant under any view to zys; 
grant merge any view to zys; 
grant drop any materialized view to zys; 
grant create materialized view to zys; 
grant create any materialized view to zys; 
grant alter any materialized view to zys;


grant create sequence to zys; 
grant create any sequence to zys; 
grant alter any sequence to zys; 
grant drop any sequence to zys; 
grant select any sequence to zys;


grant create database link to zys; 
grant create public database link to zys; 
grant drop public database link to zys; 
grant alter database to zys; 
grant administer database trigger to zys; 
grant export full database to zys; 
grant import full database to zys;




grant create role to zys; 
grant drop any role to zys; 
grant grant any role to zys; 
grant alter any role to zys;


grant force transaction to zys; 
grant force any transaction to zys; 
grant select any transaction to zys;


grant create procedure to zys; 
grant create any procedure to zys; 
grant alter any procedure to zys; 
grant drop any procedure to zys; 
grant execute any procedure to zys; 
grant debug any procedure to zys;


grant create trigger to zys; 
grant create any trigger to zys; 
grant alter any trigger to zys; 
grant drop any trigger to zys;


grant create profile to zys; 
grant alter profile to zys; 
grant drop profile to zys; 
grant drop any sql profile to zys; 
grant alter any sql profile to zys; 
grant create any sql profile to zys;


grant create type to zys; 
grant create any type to zys; 
grant alter any type to zys; 
grant drop any type to zys; 
grant execute any type to zys; 
grant under any type to zys;


grant create any directory to zys; 
grant drop any directory to zys;


grant create library to zys; 
grant create any library to zys; 
grant alter any library to zys; 
grant drop any library to zys; 
grant execute any library to zys;


grant create operator to zys; 
grant create any operator to zys; 
grant alter any operator to zys; 
grant drop any operator to zys; 
grant execute any operator to zys;


grant create indextype to zys; 
grant create any indextype to zys; 
grant alter any indextype to zys; 
grant drop any indextype to zys; 
grant execute any indextype to zys;


grant create dimension to zys; 
grant create any dimension to zys; 
grant alter any dimension to zys; 
grant drop any dimension to zys;


grant manage any queue to zys; 
grant enqueue any queue to zys; 
grant dequeue any queue to zys;


grant query rewrite to zys; 
grant global query rewrite to zys;


grant create any context to zys; 
grant drop any context to zys; 
grant create evaluation context to zys; 
grant create any evaluation context to zys; 
grant alter any evaluation context to zys; 
grant drop any evaluation context to zys; 
grant execute any evaluation context to zys;


grant create any outline to zys; 
grant alter any outline to zys; 
grant drop any outline to zys;


grant create rule set to zys; 
grant create any rule set to zys; 
grant alter any rule set to zys; 
grant drop any rule set to zys; 
grant execute any rule set to zys; 
grant create rule to zys; 
grant create any rule to zys; 
grant alter any rule to zys; 
grant drop any rule to zys; 
grant execute any rule to zys;


grant administer sql tuning set to zys; 
grant administer any sql tuning set to zys;


grant manage file group to zys; 
grant manage any file group to zys; 
grant read any file group to zys;


grant create job to zys; 
grant create any job to zys; 
grant create external job to zys;


grant select any dictionary to zys; 
grant analyze any dictionary to zys;


grant grant any privilege to zys; 
grant grant any object privilege to zys;


grant exempt access policy to zys; 
grant exempt identity policy to zys;


grant alter resource cost to zys; 
grant administer resource manager to zys;


grant sysdba to zys;


grant sysoper to zys;


grant audit any to zys;


grant analyze any to zys;


grant on commit refresh to zys;


grant resumable to zys;


grant advisor to zys;


grant execute any program to zys;


grant execute any class to zys;


grant manage scheduler to zys;


grant change notification to zys; 
  • 1
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值