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 广州

©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容

  • 一、源题QUESTION 1The instance abnormally terminates because ...
    猫猫_tomluo阅读 5,547评论 0 2
  • 一、源题QUESTION 74View the Exhibit. You want to create a tab...
    猫猫_tomluo阅读 5,496评论 0 1
  • 用了mysql好多年,很少关注mysql自带库,自然也不知道这个库里存放些什么,在看《MySQL排错指南》时看到它...
    灼灼2015阅读 5,861评论 1 3
  • 我想化作温柔的清风 总是在你身旁环绕 我想化作明媚的阳光 总能洒落在你的肩膀 你想披星戴月行走夜空 我愿星尘能抖落...
    清叶忘尘阅读 1,761评论 3 3
  • 昨晚刷知乎时看到一个问题:「从一个彻底的外行转变成互联网行业的产品经理需要多久?应该怎么努力?」,看到后瞬间就来了...
    张子恒阅读 6,096评论 25 132