oracle给用户权限grant

用户的权限来自系统权限和对象权限
下边有使用示例，做对应替换就可以执行

一、系统权限

 3个索引权限

1.Grant  CREATE ANY INDEX  to User_Name；//创建索引2.Grant ALTER ANY INDEX  to User_Name；//更改索引3.Grant DROP ANY INDEX to User_Name；//删除索引

5个存储过程权限

 CREATE    PROCEDURE CREATE   ANY   PROCEDURE ALTER    ANY   PROCEDURE EXECUTE    ANY    PROCEDURE   DROP   ANY  PROCEDURE 

4个角色权限

CREATE  ROLEALTER  ANY  ROLEDROP  ANY  ROLEGRANT  ANY   ROLE

5个序列权限

CREATE  SEQUENCE CREATE  ANY  SEQUENCEALTER  ANY  SEQUENCESELECT  ANY  SEQUENCEDROP  ANY  SEQUENCE 

登录数据库权限

CREATE SESSION

表空间权限

CREATE    TABLESPACEALTER   TABLESPACEDROP   TABLESPACEMANAGE   TABLESPACEUNLIMITED   TABLESPACE 

类型权限

CREATE    TYPECREATE   ANY   TYPEALTER   ANY   TYPE  DROP   ANY   TYPEEXECUTE  ANY   TYPEUNDER   ANY   TYPE

视图权限

CREATE   VIEWCREATE   ANY   VIEWDROP   ANY   VIEWUNDER   ANY  VIEWFLASHBACK   ANY   TABLEMERGE   ANY   VIEW

表权限

CREATE   TABLECREATE   ANY   TABLEALTER   ANY   TABLEBACKUP   ANY   TABLEDELETE   ANY   TABLEDROP   ANY   TABLEINSERT   ANY   TABLELOCK   ANY   TABLESELECT   ANY   TABLEFLASHBACK   ANY   TABLEUPDATE   ANY  TABLE 

触发器

CREATE   TRIGGERCREATE   ANY   TRIGGERALTER   ANY   TRIGGERDROP   ANY   TRIGGERADMINISTER   DATABASE   TRIGGER

备份数据库

EXP_FULL_DATABASEIMP_FULL_DATABASE

二、对象权限

具体表的操作权限：

grant select,delete,insert,update on user1.t_hr to user2;grant all on user1.t_hr to user2;

具体存储过程执行权限

grant execute on procedure1 to user1

表空间

alter user user1 default tablespace app;

限制修改的列

grant update(wage,bonus) on teachers to user1

收回权限

revoke insert on departments from user1

三、其它方面
角色有哪些权限

select * from role_sys_privs where role='xujin';

用户有哪些权限

select * from dba_role_privs where grantee=upper('用户名')With admin option  

用户sh拥有角色dw_manager的权限；可对角色分配用户；可删除角色

GRANT dw_managerTO shWITH ADMIN OPTION;With Grant option；

指定WITH GRANT OPTION以允许被授予者将对象特权授予其他用户和角色。

GRANT READ ON DIRECTORY bfile_dir TO hrWITH GRANT OPTION;

系统角色的权限

select * from dba_sys_privs where grantee='角色名称'

开发者涨薪指南 48位大咖的思考法则、工作方式、逻辑体系