Shulou(Shulou.com)06/01 Report--

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, the CONNECT role has only the CREATE SESSION privilege, allother privileges are removed.

DBA: has all privileges, is the highest privilege of the system, and only DBA can create the database structure.

RESOURCE: users with Resource permissions can only create entities, not database structures.

CONNECT: users with Connect permissions can only log in to the database, cannot create entities, and cannot create database structures.

For ordinary users: grant connect, resource permission.

For DBA administrative users: grant connect,resource, dba permissions.

SQL > select * from role_sys_privs where ROLE = 'CONNECT' ROLE PRIVILEGE ADM---CONNECT CREATE SESSION NOSQL > select * from v$version BANNER----Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit ProductionPL/SQL Release 11.2.0.4.0-ProductionCORE 11.2.0. 4.0 ProductionTNS for Linux: Version 11.2.0.4.0-ProductionNLSRTL Version 11.2.0.4.0-Production

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.