【练习】创建角色

创建角色
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.

 

转载于:https://www.cnblogs.com/tomatoes-/p/6142504.html