Oracle connect resource permission

Connect resource permission;

Grant connect, resource to user;

Subsequent User Permissions:

Connect role: -- is the most basic and typical right granted to end users.

Alter session -- modify a session

Create Cluster -- create a cluster

Create database link -- create a database link

Create sequence -- create a sequence

Create session -- create a session

Create synonym -- create a synonym

Create View -- create View

Resource role: -- grant permissions to developers

Create Cluster -- create a cluster

Create procedure -- creation process

Create sequence -- create a sequence

Create Table -- create a table

Create trigger -- create a trigger

Create type -- create type

You can find the following in dba_sys_privs:

SQL> select grantee, privilege from dba_sys_privs

2 Where grantee = 'resource' order by privilege;

Grantee privilege

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

Resource create Cluster

Resource create indextype

Resource create Operator

Resource create procedure

Resource create Sequence

Resource CREATE TABLE

Resource create trigger

Resource create type