Home  >  Article  >  Database  >  What are the roles in oracle

What are the roles in oracle

WBOY
WBOYOriginal
2022-06-13 15:45:363826browse

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.

What are the roles in oracle

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article:How to use type in oracleNext article:How to use type in oracle