사용자에 주어진 권한을 확인하는 뷰
SQL> desc system_privilege_map;
Name Null? Type
----------------------------------------- -------- ----------------------------
PRIVILEGE NOT NULL NUMBER
NAME NOT NULL VARCHAR2(40)
PROPERTY NOT NULL NUMBER
SQL> select count(*) from system_privilege_map;
COUNT(*)
----------
173
SQL>
【예제】
SQL> connect / as sysdba
SQL> create user kim ☜ 새로운 user인 kim을 만듬
2 identified by kun114$;
User created.
SQL> GRANT CREATE table, CREATE view TO jijoe; ☜ jijoe에게 권한을 부여함
Grant succeeded.
SQL> connect jijoe/arirang
Connected.
SQL> select * from USER_sys_privs; ☜ ADMIN 권한을 받았는지 확인하는 뷰
USERNAME PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
JIJOE CREATE VIEW NO
JIJOE CREATE TABLE NO
JIJOE CREATE SESSION NO
JIJOE UNLIMITED TABLESPACE NO
☜ ADM 필드가 NO이면 ADMIN 권항이 부여 되지 않았음을 나타냄
SQL> GRANT CREATE table, CREATE view TO kim; ☜ ADMIN 권한이 없는 상태에서 kim에게 권한을 주려고 함
GRANT CREATE table, CREATE view TO kim
*
ERROR at line 1:
ORA-01031: insufficient privileges ☜ 권한이 없다고 알려 줌
SQL> conn system/manager as sysdba
Connected.
SQL> grant create table, create view TO jijoe
2 WITH ADMIN OPTION; ☜ ADMIN 옵션으로 table,view를 만들 수 있는 권한을 jijoe에게 줌
Grant succeeded.
SQL> conn jijoe/arirang
Connected.
SQL> select * from user_sys_privs; ☜ ADMIN 권한을 받았는지 확인하는 뷰
USERNAME PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
JIJOE CREATE VIEW YES
JIJOE CREATE TABLE YES
JIJOE CREATE SESSION NO
JIJOE UNLIMITED TABLESPACE NO
☜ ADM 필드가 YES이면 ADMIN 권한이 부여 되었음을 나타냄
SQL> GRANT CREATE table, CREATE view TO kim;
☜ ADMIN 권한을 부여 받은 jijoe가 사용자 kim에게 권한을 부여할 수 있음
Grant succeeded.
SQL>