Oracle's explanation of pre-defined roles

Oracle's explanation of pre-defined roles

A role is a collection of related permissions. Using a role can simplify permission management. In short, oracle can combine a series of permissions (roles) in advance and package them to the user, so that the user has a series of permissions for the role.

There are 25 predefined oracle roles, which are provided by oracle. Commonly used roles include connect, resource, and dba. To create a user, you only need to assign the connect and resource roles to the user in most cases.

The connect role has most of the permissions required by general application developers. The system permissions of the connect role are as follows:

Alter session

Create cluster

Create database link

Create session

Create table

Create view

Create sequence

The resource role has other permissions required by developers, such as creating stored procedures and triggers, and the resource role. The resource role implies the unlimited tablespace system permissions (unrestricted tablespace ), resource System permissions include:

Create cluster

Create indextype

Create table

Create sequence

Create type

Create procedure

Create trigger

The dba role has all system permissions and the with admin option. By default, dba users are sys and system. They can grant any system permissions to other users. However, the dba role does not have the permissions of sysdba and sysoper, that is, to start and close the database.