MariaDB/SQL/user

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot

< MariaDB | SQL

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

Retrieved from "https://htyp.org/mw/index.php?title=MariaDB/SQL/user&oldid=29396"