Role 관리

Role 관리 실습 

 

SQL> conn /as sysdba
Connected.

SQL> col PRIVILEGE format a20

SQL> select * from dba_sys_privs where grantee = 'RESOURCE';

 

 

SQL> create role dev;

Role created.

 

SQL> grant create table, create view to dev;

Grant succeeded.

 

SQL> grant select on scott.emp to dev;

Grant succeeded.

 

SQL> grant dev,connect,resource to bob;

Grant succeeded.

 

SQL> select * from dba_role_privs where grantee='BOB';

 

 

SQL> alter user bob default role connect,resource;

User altered.

 

SQL> conn bob/linux
Connected.

SQL> select * from session_roles;

SQL> select * from scott.emp;
select * from scott.emp
                    *
ERROR at line 1:
ORA-00942: table or view does not exist

 

SQL> set role all;

Role set.

 

SQL> select * from session_roles;

 

SQL> select * from scott.emp where ename like '%SC%';