MariaDB/SQL/user

SQL commands for managing user accounts

{{#set: page title=SQL commands for managing user accounts }}

Commands

• ALTER USER
• CREATE ROLE
• CREATE USER
• DROP ROLE
• DROP USER
• GRANT: grant privileges to user-accounts
• RENAME USER
• REVOKE
• SET DEFAULT ROLE
• SET PASSWORD
• SET SESSION AUTHORIZATION
• SET ROLE

user security

• SHOW GRANTS: list all granted privileges (privilege x user)
• SHOW PRIVILEGES: list all defined privilege-types (can be assigned to users)

Reference

• Account Management