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

Jump to navigation Jump to search

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"

Facts

... more about "MariaDB/SQL/user"

SQL commands for managing user accounts +