关于权限的简单实验

connect角色有什么系统权限？

 

SQL> select PRIVILEGE from dba_sys_privs where GRANTEE='CONNECT';

 

PRIVILEGE

----------------------------------------

CREATE SESSION

 

 

resource角色有什么系统权限？

 

SQL> select PRIVILEGE from dba_sys_privs where GRANTEE='RESOURCE';

 

PRIVILEGE

----------------------------------------

CREATE TRIGGER

CREATE SEQUENCE

CREATE TYPE

CREATE PROCEDURE

CREATE CLUSTER

CREATE OPERATOR

CREATE INDEXTYPE

CREATE TABLE

 

8 rows selected.

 

给SWZ授予connect和resource

 

SQL> select PRIVILEGE from dba_sys_privs where GRANTEE='SWZ';

 

PRIVILEGE

----------------------------------------

UNLIMITED TABLESPACE

 

SQL> select GRANTED_ROLE from dba_role_privs where GRANTEE='SWZ';

 

GRANTED_ROLE

------------------------------

RESOURCE

CONNECT

 

 

用户查看自己的权限

 

SQL> conn swz/swz;

Connected.

SQL> select * from user_sys_privs;

 

USERNAME                     PRIVILEGE                                   ADM

------------------------------ ---------------------------------------- ---

SWZ                         UNLIMITED TABLESPACE                  NO

 

SQL> select * from session_privs;

 

PRIVILEGE

----------------------------------------

CREATE SESSION

UNLIMITED TABLESPACE

CREATE TABLE

CREATE CLUSTER

CREATE SEQUENCE

CREATE PROCEDURE

CREATE TRIGGER

CREATE TYPE

CREATE OPERATOR

CREATE INDEXTYPE

 

10 rows selected.

 

SQL> SELECT * FROM SESSION_ROLES;

 

ROLE

------------------------------

CONNECT

RESOURCE

 

 

 

SESSION_PRIVS describes the privileges that are currently available to the user.

Column	Datatype	NULL	Description
PRIVILEGE	VARCHAR2(40)	NOT NULL	Name of the privilege

 

USER_SYS_PRIVS describes system privileges granted to the current user.

Column	Datatype	NULL	Description
USERNAME	VARCHAR2(30)		Name of the user, or PUBLIC
PRIVILEGE	VARCHAR2(40)	NOT NULL	System privilege
ADMIN_OPTION	VARCHAR2(3)		Indicates whether the grant was with the ADMIN option (YES) or not (NO)

 

 

SESSION_ROLES describes the roles that are currently enabled to the user.

Column	Datatype	NULL	Description
ROLE	VARCHAR2(30)	NOT NULL	Name of the role

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30935525/viewspace-2123185/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30935525/viewspace-2123185/