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
No edit summary |
No edit summary |
||
| Line 6: | Line 6: | ||
* <code>[[../DROP/]] {{l/pfx|../DROP/|ROLE}}</code> | * <code>[[../DROP/]] {{l/pfx|../DROP/|ROLE}}</code> | ||
* <code>[[../DROP/]] {{l/pfx|../DROP/|USER}}</code> | * <code>[[../DROP/]] {{l/pfx|../DROP/|USER}}</code> | ||
* <code>[[../GRANT/]]</code> | * <code>[[../GRANT/]]</code>: grant privileges to user-accounts | ||
* <code>[[../RENAME/]] USER</code> | * <code>[[../RENAME/]] USER</code> | ||
* <code>[[../REVOKE/]]</code> | * <code>[[../REVOKE/]]</code> | ||
| Line 14: | Line 14: | ||
* <code>[[../SET/]] ROLE</code> | * <code>[[../SET/]] ROLE</code> | ||
===user security=== | ===user security=== | ||
* <code>[[../SHOW/]] {{l/pfx|../SHOW/|GRANTS}}</code>: list all granted privileges (privilege x user) | |||
* <code>[[../SHOW/]] {{l/pfx|../SHOW/|PRIVILEGES}}</code>: list all defined privilege-types (can be assigned to users) | * <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] | ||
Latest revision as of 01:03, 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/]]: grant privileges to user-accounts[[../RENAME/]] USER[[../REVOKE/]][[../SET/]] DEFAULT ROLE[[../SET/]] PASSWORD[[../SET/]] SESSION AUTHORIZATION[[../SET/]] ROLE
user security
[[../SHOW/]] Template:L/pfx: list all granted privileges (privilege x user)[[../SHOW/]] Template:L/pfx: list all defined privilege-types (can be assigned to users)
