Outdated Version
You are viewing an older version of this section. View current production version.
SHOW GRANTS
Show permissions for the specified user.
Syntax
SHOW GRANTS FOR user@domain;
Remarks
user@domain
- user for whom to show grants- This command can be run on any MemSQL node. For more information, see Node Requirements for MemSQL Commands.
Example
memsql> SHOW GRANTS;
+---------------------------------------------------------------------+
| Grants for root@localhost |
+---------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION |
+---------------------------------------------------------------------+
1 row in set (0.00 sec)