oracle 用户授权resource_我把Oracle用户授权比作上战场打篮球

-- Create the user

1、用户创建

create user SCOTT

default tablespace SCOTT_DATA

temporary tablespace TEMP

profile DEFAULT;

-- Grant/Revoke object privileges

2、对象

grant select on TEST.TB_01 to SCOTT;

grant select on TEST.TB_02 to SCOTT;

grant select on TEST.TB_03 to SCOTT;

-- Grant/Revoke role privileges

3、角色控制

grant connect to SCOTT;

grant dba to SCOTT;

grant resource to SCOTT;

4、系统权限

-- Grant/Revoke system privileges

grant create any sequence to SCOTT;

grant create any trigger to SCOTT;

grant create any view to SCOTT;

grant create view to SCOTT;

grant delete any table to SCOTT;

grant execute any class to SCOTT;

grant execute any procedure to SCOTT;

grant insert any table to SCOTT;

grant select any sequence to SCOTT;

grant select any table to SCOTT;

grant unlimited tablespace to SCOTT;

grant update any table to SCOTT;

(欢迎转载)