oracle权限、角色的管理！

  --创建、删除角色：

SQL> create role r1;角色已创建。SQL> drop role r1;角色已删除。

 

--授予、撤销权限：

SQL> grant connect,resource to ing;授权成功。SQL> revoke connect,resource from ing;撤销成功。

 

--查看数据库中所有的角色：(不加限制条件的话)

SQL> select role from dba_roles where rownum < 3;ROLE------------------------------CONNECTRESOURCE

 

--查看数据库中所有的系统权限： (不加限制条件的话)

SQL> select * from system_privilege_map where rownum < 5; PRIVILEGE NAME                                       PROPERTY---------- ---------------------------------------- ----------        -3 ALTER SYSTEM                                      0        -4 AUDIT SYSTEM                                      0        -5 CREATE SESSION                                    0        -6 ALTER SESSION                                     0

 

--查看数据库中所有的对象权限：  (不加限制条件的话)

SQL> select * from table_privilege_map where rownum < 5; PRIVILEGE NAME---------- ----------------------------------------         0 ALTER         1 AUDIT         2 COMMENT         3 DELETE

--查看用户拥有的角色：

SQL> grant connect,resource to ing;授权成功。SQL> select GRANTED_ROLE from dba_role_privs where GRANTEE = 'ING';GRANTED_ROLE------------------------------CONNECTRESOURCE

 

--查看用户拥有的权限：

SQL> select PRIVILEGE from dba_sys_privs where GRANTEE = 'ING';PRIVILEGE----------------------------------------UNLIMITED TABLESPACE

--查看角色拥有的系统权限：

SQL> select PRIVILEGE from role_sys_privs where role = 'CONNECT';PRIVILEGE----------------------------------------CREATE SESSIONSQL> select PRIVILEGE from dba_sys_privs where GRANTEE = 'CONNECT';PRIVILEGE----------------------------------------CREATE SESSIONSQL> select PRIVILEGE from role_sys_privs where role = 'RESOURCE';PRIVILEGE----------------------------------------CREATE SEQUENCECREATE TRIGGERCREATE CLUSTERCREATE PROCEDURECREATE TYPECREATE OPERATORCREATE TABLECREATE INDEXTYPE已选择8行。SQL> select PRIVILEGE from dba_sys_privs where GRANTEE = 'RESOURCE';PRIVILEGE----------------------------------------CREATE TRIGGERCREATE SEQUENCECREATE TYPECREATE PROCEDURECREATE CLUSTERCREATE OPERATORCREATE INDEXTYPECREATE TABLE已选择8行。

 

--查看自己拥有的角色：

SQL> conn ing/ing已连接。SQL> select * from session_roles;ROLE------------------------------CONNECTRESOURCE

 

--查看自己拥有的权限：

SQL> conn ing/ing已连接。SQL> select * from session_privs;PRIVILEGE----------------------------------------CREATE SESSIONUNLIMITED TABLESPACECREATE TABLECREATE CLUSTERCREATE SEQUENCECREATE PROCEDURECREATE TRIGGERCREATE TYPECREATE OPERATORCREATE INDEXTYPE已选择10行。