User Management

Overview

Create and manage database users. Usernames must be 1-64 characters, alphanumeric with underscores and dashes. Passwords must be 6-128 characters.

User Statements

Creating Users

GQL
CREATE USER 'analyst' WITH PASSWORD 'secure_password_123'

Altering Users

Change password:

GQL
ALTER USER 'analyst' SET PASSWORD 'new_password_456'

Deactivate a user:

GQL
ALTER USER 'analyst' SET STATUS INACTIVE

Reactivate a user:

GQL
ALTER USER 'analyst' SET STATUS ACTIVE

Rename a user:

GQL
ALTER USER 'analyst' RENAME TO 'senior_analyst'

Dropping Users

GQL
DROP USER 'analyst'

Use IF EXISTS to avoid errors:

GQL
DROP USER IF EXISTS 'analyst'

Showing Users

List all users:

GQL
SHOW USERS

Result:

Show specific user:

GQL
SHOW USER analyst