DCL 数据控制语言

授予用户权限

GRANT 权限 TO 用户
权限分类：

• create session 登录
• create table
• create view
• create sequence
• create procudure
• create synonym
• unlimited tablespace

SQL> grant create session, create table, create view, create sequence, create synonym, create procedure, unlimited tablespace to tester;
Grant succeeded

撤销用户权限

REVOKE 权限 FROM 用户

SQL> revoke create session, create table, create view, create sequence, create synonym, create procedure, unlimited tablespace from tester;
Revoke succeeded

创建角色

SQL> create role emp_manager;
Role created

授予权限给角色

授予角色给用户