SHOW GRANTS
On this page
Show permissions (privileges) for the specified user (or role).
Syntax
SHOW GRANTS [FOR {user | role}]user:'user'@'host_name'role:ROLE 'role_name'
Arguments
-
'user'@'host_- user for which to show privileges.name' If a hostname is not specified, @'%'will be appended to the user string.For example, 'demo-user'is equivalent to'demo-user'@'%'.The '%'wildcard matches any hostname.userandhost_need not be quoted if they are legal as unquoted identifiers.name Quotes must be used if a host_string contains wildcard characters (such asname %), or a user string contains special characters (such as space or-) or is a restricted keyword. -
'role_- role for which to show privilegesname'
Remarks
-
This command can be run on any SingleStore node.
For more information, see Node Requirements for SingleStore Commands. -
Refer to the Permission Matrix for the required permission.
Example
The SHOW GRANTS command displays the privileges assigned to the current user.
SHOW GRANTS;
+---------------------------------------------------------------------+
| Grants for root@% |
+---------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' |
+---------------------------------------------------------------------+
+---------------------------------------------------------------------+
| Grants for user1@% |
+---------------------------------------------------------------------+
| GRANT SELECT, INSERT ON `mydb`.* TO 'user1'@' [WITH GRANT OPTION] |
| |
+---------------------------------------------------------------------+The SHOW GRANTS FOR command displays the privileges assigned to the specified user.
SHOW GRANTS FOR user1;
+---------------------------------------------------------------------+
| Grants for user1@% |
+---------------------------------------------------------------------+
| GRANT SELECT, INSERT ON `mydb`.* TO 'user1'@' [WITH GRANT OPTION] |
| |
+---------------------------------------------------------------------+The SHOW GRANTS FOR ROLE command displays the grants assigned to the role specified in the query.rw
.
SHOW GRANTS FOR ROLE 'rw';
+---------------------------------------------------------------------------------+
| Grants for role rw |
+---------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO ROLE 'rw' |
| ' |
+---------------------------------------------------------------------------------+Last modified: April 27, 2023