Privileges 관리

실습 : 권한 관리 

 

SQL> alter user bob identified by linux; //bob 에 대한 유저를 linux로 패스워드 변경

 

SQL> grant create user to scott with admin option;

 

SQL> conn scott/tiger
Connected.

SQL> grant create user to bob;

Grant succeeded.

 

 

SQL> select * from dba_sys_privs where grantee in ('SCOTT','BOB');

 

 

SQL> revoke create user from scott;

Revoke succeeded.

 

SQL> select * from dba_sys_privs where grantee in ('SCOTT','BOB');

 

 

SQL> create user rose identified by rose
  2  default tablespace test
  3  temporary tablespace TEMP;

User created.

 

SQL> conn scott/tiger
Connected.

SQL> grant select on dept to bob with grant option
 Grant succeeded.

 

 

SQL> conn bob/linux
Connected.

SQL> grant select on scott.dept to rose;

Grant succeeded.

 

SQL> conn scott/tiger
Connected.

SQL> col grantor format a15
SQL> col grantee format a15
SQL> col table_schema format a15
SQL> col table_name format a15
SQL> col privilege format a15
SQL> col privilege format a15
SQL> col gra format a10
SQL> select * from all_tab_privs where table_name = 'DEPT';