User Access levels

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

:::