What are the roles in oracle

Roles in oracle: 1. "connect role" connection role. Temporary users refer to users who do not need to create tables; 2. "resource role" resource role, which provides users with additional permissions to create their own tables. ;3. "dba role" database administrator role, including unlimited space quotas and the ability to grant various permissions to other users.

The operating environment of this tutorial: Windows 10 system, Oracle version 12c, Dell G3 computer.

What roles are there in oracle

A role is a named collection of related permissions. The main purpose of using roles is to simplify permission management

CONNECT is automatically created, including the following permissions : ALTER SESSION, CREATE CLUSTER, CREATE DATABASELINK, CREATE SEQUENCE, CREATE SESSION, CREATE SYNONYM, CREATE TABLE, CREATEVIEW.

RESOURCE is automatically created, including the following permissions: CREATE CLUSTER, CREATE PROCEDURE, CREATE SEQUENCE, CREATE TABLE, CREATE TRIGGR

Oracle is compatible with previous versions and provides three standard roles: connect /resource and dba.

Three standard roles:

1. connect role

-- Temporary users, specifically those who do not need to create tables, usually only give them the connect role.

--connect uses Oracle simple permissions. This permission only has access rights to other users' tables, including select/ insert/update and delete etc.

--Users with connect role can also create tables, views, sequences, clusters, synonyms, sessions and other data links

2. resource role(resource role)

--More reliable and formal database users can be granted resource role.

--resource provides users with additional permissions to create their own tables, sequences, procedures, triggers, indexes, and clusters.

3. dba role (database administrator role)

--dba role has all system permissions

--including unlimited space Quotas and the ability to grant various permissions to other users. The system is owned by the dba user

(2) Authorization command

Syntax: grant connect, resource to user name;

Example: grant connect, resource to test;

(3) Revoke permission

Syntax: revoke connect, resource from user name;

Example: revoke connect, resource from test;

Recommended tutorial:《Oracle Video Tutorial》

The above is the detailed content of What are the roles in oracle. For more information, please follow other related articles on the PHP Chinese website!