MariaDB/SQL/user: Difference between revisions
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Created page with "{{fmt/title|SQL commands for managing user accounts}} ==Commands== * <code>../ALTER/ {{l/pfx|../ALTER/|USER}}</code> * <code>../CREATE/ {{l/pfx|../CREATE/|ROLE}}</code..." |
No edit summary |
||
| Line 13: | Line 13: | ||
* <code>[[../SET/]] SESSION AUTHORIZATION</code> | * <code>[[../SET/]] SESSION AUTHORIZATION</code> | ||
* <code>[[../SET/]] ROLE</code> | * <code>[[../SET/]] ROLE</code> | ||
===user security=== | |||
* <code>[[../SHOW/]] {{l/pfx|../SHOW/|PRIVILEGES}}</code>: list all defined privilege-types (can be assigned to users) | |||
==Reference== | ==Reference== | ||
* [https://mariadb.com/docs/server/reference/sql-statements/account-management-sql-statements Account Management] | * [https://mariadb.com/docs/server/reference/sql-statements/account-management-sql-statements Account Management] | ||
Revision as of 00:56, 26 April 2026
|
SQL commands for managing user accounts
|
{{#set: page title=SQL commands for managing user accounts }}
Commands
ALTER USERCREATE ROLECREATE USERDROP ROLEDROP USERGRANTRENAME USERREVOKESET DEFAULT ROLESET PASSWORDSET SESSION AUTHORIZATIONSET ROLE
user security
SHOW PRIVILEGES: list all defined privilege-types (can be assigned to users)
