Outdated Version

You are viewing an older version of this section. View current production version.

SHOW GRANTS

Show permissions for the specified user.

SHOW GRANTS FOR user@domain;

Notes

  • user@domain - user for whom to show grants
  • This command can be run on any MemSQL node (see Node_Requirements).

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)