dcsimg
 

Submitted by: M S Sridhar(sridhar.ms@gmail.com)

Monday May 21st 2018 by M S Sridhar

Language: SQL, Expertise: Intermediate - Learn how to master the GRANT command to have varied output.

The command "SHOW GRANTS" will display the privileges that the current user has.

Command: SHOW GRANTS

Sample output:

+------------------------------------------------------------------------------------------------------------------+
|Grants for dbuser@%                                                                                               |
+------------------------------------------------------------------------------------------------------------------+
|  GRANT ALL PRIVILEGES ON *.* TO 'dbuser'@'%' IDENTIFIED BY PASSWORD '*03E51IIDCEYB2B07FF7A98489A5C0E905A7087BC'  |
+------------------------------------------------------------------------------------------------------------------+

You can master the GRANT command to have varied output. Be cautious while using GRANT as you may be restricting the permission(s) to the user.

Home
Mobile Site | Full Site
Copyright 2018 © QuinStreet Inc. All Rights Reserved