授予用户权限
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
授予权限给角色
网友评论