Oracle中的所有权限-by小雨

本文纯属个人见解,是对前面学习的总结,如有描述不正确的地方还请高手指正~

    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; 

文章结束给大家分享下程序员的一些笑话语录: 真正的程序员喜欢兼卖爆米花,他们利用CPU散发出的热量做爆米花,可以根据米花爆裂的速度听出正在运行什么程序。

posted @ 2013-04-18 16:24  坚固66  阅读(169)  评论(0编辑  收藏  举报