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)

Was this Article Helpful?

Thanks For Your Feedback!