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
Commands
[[../ALTER/]] Template:L/pfx[[../CREATE/]] Template:L/pfx[[../CREATE/]] Template:L/pfx[[../DROP/]] Template:L/pfx[[../DROP/]] Template:L/pfx[[../GRANT/]][[../RENAME/]] USER[[../REVOKE/]][[../SET/]] DEFAULT ROLE[[../SET/]] PASSWORD[[../SET/]] SESSION AUTHORIZATION[[../SET/]] ROLE
user security
[[../SHOW/]] Template:L/pfx: list all defined privilege-types (can be assigned to users)
