创建角色
1)创建角色sse_role,授予create session 权限

SQL> create role sse_role;

Role created.

SQL> grant create session to sse_role;

Grant succeeded.


2)创建角色tblo_role,授予CREATE PROCEDURE, CREATE SEQUENCE, CREATE SYNONYM, CREATE TABLE, CREATE TRIGGER, CREATE TYPE, CREATE VIEW 权限

SQL> create role tblo_role;

Role created.

SQL> grant CREATE PROCEDURE, CREATE SEQUENCE, CREATE SYNONYM, CREATE TABLE, CREATE TRIGGER, CREATE TYPE, CREATE VIEW to tblo_role;

Grant succeeded.

 

posted on 2016-12-07 20:01  Tomatoes  阅读(132)  评论(0编辑  收藏  举报