【练习】创建角色

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.