User Access levels
  • 25 May 2022
  • 1 読む分
  • PDF

User Access levels

  • PDF

The content is currently unavailable in Ja - 日本語. You are viewing the default English version.
記事の要約

An Individual who can perform various database-related operations on Element DB is a User. Element DB supports five kinds of user access levels.

  • EL_ADMIN is the super admin who can:
  1. Perform all database-related query operations.
  2. Manage peers and users.
  3. Here, the user can create new users or assign users to the databases.
  • DB_ADMIN users can:
  1. Perform all database-related operations like the super admin but cannot create new users.
  2. Can assign a pre-existing user to a database.
  • DDL (Data Definition Language) users can:
  1. Perform Create, Read, Update and Delete operations, also known as CRUD operations.

  2. They perform these operations for creating structures such as tables or indexes for a database.

  3. The CRUD operations include the following queries:

  • Create Table
  • Alter Table
  • Show Table
  • Drop-Table
  • Insert Into
  • Update Record
  • Delete Record
  • Select
  • DML_WRITE users can:
  1. Insert new records into an existing database.
  2. Update existing records of a database.
  • DML_READ - users can:
  1. Fetch pre-existing records in the database.
  2. View the pre-existing records in the database.

Access Level:

There are 2 SQL queries - DDL and DML:

DDL is Data Definition Language. It refers to the queries where we want to create a structure. Table creation and Index creation come under DDL.
DML is Data Manipulation Language, which allows tampering and changing the records.
DML_WRITE allows updating the records.
DML_READ allows only to read the records and cannot perform any update operations on them.

EL_ADMIN > DB_ADMIN > DDL > DML_WRITE > DML_READ

Access-level-Element-DB.png

Access Level

:::


この記事は役に立ちましたか?

What's Next
Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.