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
|
SQL commands for managing user accounts
|
{{#set: page title=SQL commands for managing user accounts }}
Commands
ALTER USERCREATE ROLECREATE USERDROP ROLEDROP USERGRANT: grant privileges to user-accountsRENAME USERREVOKESET DEFAULT ROLESET PASSWORDSET SESSION AUTHORIZATIONSET ROLE
user security
SHOW GRANTS: list all granted privileges (privilege x user)SHOW PRIVILEGES: list all defined privilege-types (can be assigned to users)
