USAGE Privilege
This page is part of MariaDB's Documentation.
The parent of this page is: Privileges for MariaDB Xpand
Topics on this page:
Overview
Grants ability to connect to the database server.
DETAILS
Scope: Global
Privilege name for
GRANT:USAGEPrivilege name for
REVOKE:USAGEPrivilege shown by
SHOW GRANTS:USAGE
EXAMPLES
GRANT
The following examples demonstrate grant of a single privilege. A single GRANT statement can grant multiple privileges at the same scope by providing a comma-separated list of the privileges.
To grant USAGE privilege at global scope, replace the user specification ('USERNAME'@'HOSTNAME') in the following query to align to your requirements:
GRANT USAGE
ON *.*
TO 'USERNAME'@'HOSTNAME';
REVOKE
The USAGE privilege can not be revoked.
SHOW Output
A user's privileges can be displayed using the SHOW GRANTS statement.
SHOW GRANTS FOR 'app_user'@'192.0.2.%';
+-------------------------------------------------+
| Grants for app_user@192.0.2.% |
+-------------------------------------------------+
| GRANT USAGE ON `*.*` TO 'app_user'@'192.0.2.%' |
+-------------------------------------------------+
Privilege Failure
The USAGE privilege results in no failures.