> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-statements/account-management-sql-statements.md).

# Account Management

{% columns %}
{% column %}
{% content-ref url="/pages/lez9INSGCeTsojW8eQfW" %}
[ALTER USER](/docs/server/reference/sql-statements/account-management-sql-statements/alter-user.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete ALTER USER guide for MariaDB. Complete syntax for modifying authentication, passwords, and account security settings with comprehensive examples and.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/ScMVT93GOAsvD8TDhmqq" %}
[CREATE ROLE](/docs/server/reference/sql-statements/account-management-sql-statements/create-role.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Create new roles to simplify privilege management. Learn how to define a role that can be assigned to multiple users or other roles.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/SSTlNfjevjhycQ2TG9NF" %}
[CREATE USER](/docs/server/reference/sql-statements/account-management-sql-statements/create-user.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete guide to creating MariaDB user accounts. Complete CREATE USER syntax for authentication methods and password policies with comprehensive examples.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/njD6aTfnELO8atgftqYg" %}
[DROP ROLE](/docs/server/reference/sql-statements/account-management-sql-statements/drop-role.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Remove a role from the system. Learn the syntax to delete defined roles and revoke them from any users or roles that currently hold them.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/p3ZOpieqafFAB6BZ4Mwp" %}
[DROP USER](/docs/server/reference/sql-statements/account-management-sql-statements/drop-user.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete DROP statement reference for MariaDB. Complete guide for safely removing database objects with CASCADE options with comprehensive examples and best.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/7RL7uJxGIOUSEeiDXdZt" %}
[GRANT](/docs/server/reference/sql-statements/account-management-sql-statements/grant.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete privilege management guide for MariaDB. Complete GRANT syntax for database, table, and column permissions with roles with comprehensive examples and.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/24bKz24CecbvFLaLR6TP" %}
[RENAME USER](/docs/server/reference/sql-statements/account-management-sql-statements/rename-user.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Rename existing database accounts. This guide explains how to change a user's name while preserving their current privileges and properties.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/0eEmKmLiEOljFsCSGMwR" %}
[REVOKE](/docs/server/reference/sql-statements/account-management-sql-statements/revoke.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Remove privileges or roles. Learn how to withdraw previously granted permissions from users or roles to restrict access and secure the database.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/hBVPtauyKfBBBYAQNHC3" %}
[SET DEFAULT ROLE](/docs/server/reference/sql-statements/account-management-sql-statements/set-default-role.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Define the default role for a user. Learn how to configure which role is automatically active when a user connects to the server.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/TfaL3k4x5x7bFuE9e6Dl" %}
[SET PASSWORD](/docs/server/reference/sql-statements/account-management-sql-statements/set-password.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete reference for SET PASSWORD in MariaDB. Complete syntax guide with all options, clauses, and practical examples with comprehensive examples and best.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/uzhz69xueX4uF7R7YCul" %}
[SET SESSION AUTHORIZATION](/docs/server/reference/sql-statements/account-management-sql-statements/set-session-authorization.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Impersonate another user for the current session. Learn how to assume the identity and privileges of another account for testing or administration.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/BXecw1iZYqgUJrtCJZq3" %}
[SET ROLE](/docs/server/reference/sql-statements/account-management-sql-statements/set-role.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Sets the current role for the session. Learn how to enable none, or a specific role to change your current privileges dynamically.
{% endcolumn %}
{% endcolumns %}