Oracle conncect role vs create session

Oracle conncect role vs create session

The CONNECT role was introduced with OracleDatabase version 7,which added new and robust support for database roles. TheCONNECT role is used in sample code,applications,documentation,and technicalpapers. The CONNECT role was established with the following privileges :

Privileges Originally Associated with the CONNECT Role

Alter Session Create Session

Create Cluster Create Synonym

Create Database Link Create Table

Create Sequence Create View

However,beginning in Oracle Database 10gRelease 2 (10.2),the CONNECT role has only the CREATE SESSION privilege,allother privileges are removed.

DBA:拥有全部特权，是系统最高权限，只有DBA才可以创建数据库结构。
RESOURCE:拥有Resource权限的用户只可以创建实体，不可以创建数据库结构。
CONNECT:拥有Connect权限的用户只可以登录数据库，不可以创建实体，不可以创建数据库结构。
对于普通用户：授予connect,resource权限。
对于DBA管理用户：授予connect，resource,dba权限。

SQL>select*fromrole_sys_privswhereROLE='CONNECT';
ROLEPRIVILEGEADM
-------------------------------------------------------------------------
CONNECTCREATESESSIONNO
SQL>select*fromv$version;
BANNER
--------------------------------------------------------------------------------
OracleDatabase11gEnterpriseEditionRelease11.2.0.4.0-64bitProduction
PL/SQLRelease11.2.0.4.0-Production
CORE11.2.0.4.0Production
TNSforLinux:Version11.2.0.4.0-Production
NLSRTLVersion11.2.0.4.0-Production

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!