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

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)