All Products
Search
Document Center

Lindorm:DCL

Last Updated:Aug 29, 2025

Data Control Language (DCL) provides syntax for user role management and permission management.

The following table describes the supported DCL commands, the required permissions, and the supported granularity levels.

Important

The ALL or ALL PRIVILEGES permission includes the READ, WRITE, ADMIN, and TRASH permissions. If you grant the ALL permission, you also grant these four permissions.

The following table lists only non-ALL permissions.

Command classification

Command

Description

Required permissions

Supported granularity

User role management

CREATE USER

Creates a new user.

Requires both ADMIN and READ permissions.

GLOBAL

ALTER USER

Changes the password of a user.

Requires both ADMIN and READ permissions.

GLOBAL

SHOW USERS

Views existing users. Before you create a new user, run this command to check for existing usernames to prevent errors.

  • READ

  • WRITE

  • ADMIN

  • GLOBAL

  • DATABASE

  • TABLE

DROP USER

Deletes an existing user.

Requires both ADMIN and READ permissions.

GLOBAL

User permission management

GRANT

Grants permissions to a specified user. Before you grant permissions, understand the supported permissions, permission scopes, and grantable objects in Lindorm.

ADMIN

GLOBAL

REVOKE

Revokes permissions from a user.

ADMIN

GLOBAL