角色:权限的集合

    三种标准的角色:
    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;