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.

USER_SYS_PRIVS describes system privileges granted to the current user.

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