角色:权限的集合
三种标准的角色:
connect(连接角色)
resource(资源角色)
dba(数据库管理员角色)
例如:connect /as sysdba
create user user01 identified by pass01;
grant connect to user01;
connect user01/pass01;
connect /as sysdba
grant resource to user01;
connect user01/pass01;
create table test
connect /as sysdba
grant dba to user01;
connect user01/pass01;
create user user02 identified by pass02;
创建角色:
create role manager;
将角色赋予用户:
grant manager to user01,user02;
例如:connect /as sysdba
create user user02 identified by pass02;
create role manager;
grant create table,create view to manager;
grant manager to user02;
revoke manager from user02;
