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%';
'Oracle DataBase > Admin' 카테고리의 다른 글
Privileges 관리 (0) | 2012.06.08 |
---|---|
User 생성과 관리 (0) | 2012.06.08 |
PROFILE 생성과 관리 (0) | 2012.06.08 |
테이블스페이스 생성과 관리 (0) | 2012.06.08 |
Redo log file 구성 및 관리 (0) | 2012.06.08 |