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

上一个：EBS后台取消死锁检查代码和取消死锁会话步骤---经验
下一个：GoldenGate单向DDL同步

更多图片编程知识:

更多Oracle疑问解答：: 运行exp备份oracle数据库提示oracle-12154错误; 有没有，生产Oracle Rman 备份脚本的工具啊！; 初学orcle，希望有大大帮忙解说一下详细步骤，从登录oracle到创建表的过程; oracle语句问题：一张user表，三个字段，id,name,time，插入记录比如：张三2007，李四2008，张三2011; 如何写一个ORACLE触发器同步两个表中的数据？; oracle 如何查看一个服务器上有多少个数据库.; oracle 创建包的时候错误求解; oracle 重复列的问题; oracle 中如何查处2星期前的数据; 请教oracle数据库安装中的问题; 请问谁能提供给我标准的oracle ERP的数据库表结构并详细说明各表主要的作用?; 安装oracle遇到的问题 invalid entry CRC (expected 0x3e12e795 but got 0x9db0e9fd); 我的是ORACLE 10G，在RMAN中如何按指定的时间恢复数据文件啊？; oracle为什么没有自动增长列; oracle快捷键都有哪些啊？