CONNECT AND RESOURCE权限比较

SQL> select privilege from role_sys_privs where role like '%CONNECT%';

PRIVILEGE
----------------------------------------
CREATE VIEW
CREATE TABLE
ALTER SESSION
CREATE CLUSTER
CREATE SESSION
CREATE SYNONYM
CREATE SEQUENCE
CREATE DATABASE LINK

8 rows selected.

SQL> select privilege from role_sys_privs where role like '%RESOURCE%';

PRIVILEGE
----------------------------------------
CREATE TYPE
CREATE TABLE
CREATE CLUSTER
CREATE TRIGGER
CREATE OPERATOR
CREATE SEQUENCE
CREATE INDEXTYPE
CREATE PROCEDURE

CONNECT AND RESOURCE比较

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

CONNECT中和RESOURCE 不同的权限

SQL> select privilege from role_sys_privs where role like '%CONNECT%'
  2  MINUS
  3  select privilege from role_sys_privs where role like '%RESOURCE%';

PRIVILEGE
----------------------------------------
ALTER SESSION
CREATE DATABASE LINK
CREATE SESSION
CREATE SYNONYM
CREATE VIEW

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

两者相同权限

SQL> select privilege from role_sys_privs where role like '%CONNECT%'
  2  INTERSECT
  3  select privilege from role_sys_privs where role like '%RESOURCE%';

PRIVILEGE
----------------------------------------
CREATE CLUSTER
CREATE SEQUENCE
CREATE TABLE