CONNECT AND RESOURCE权限比较

最新推荐文章于 2019-10-30 10:58:16 发布

原创最新推荐文章于 2019-10-30 10:58:16 发布 · 1.1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#session #database #table #sql

Oracle 专栏收录该内容

60 篇文章

订阅专栏

本文通过SQL查询详细对比了数据库中CONNECT与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