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;

From 20171225 广州
