8
Account Management SQL Commands
CREATE/DROP USER, GRANT, REVOKE, SET PASSWORD etc.
-
CREATE USER
Create new MariaDB accounts. -
ALTER USER
Modify an existing MariaDB account. -
DROP USER
Remove one or more MariaDB accounts. -
GRANT
Create accounts and set privileges or roles. -
RENAME USER
Rename user account. -
REVOKE
Remove privileges or roles. -
SET PASSWORD
Assign password to an existing MariaDB user. -
CREATE ROLE
Add new roles. -
DROP ROLE
Drop a role. -
SET ROLE
Enable a role. -
SET DEFAULT ROLE
Sets a default role for a specified (or current) user. -
SHOW GRANTS
View GRANT statements. -
SHOW CREATE USER
Show the CREATE USER statement that creates a specified user.
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
