Oracle中的所有权限(一)

2014-11-24 13:04:18 · 作者: · 浏览: 1
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;