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.
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!