Show Permission : Permission « User Permission « SQL / MySQL






  1. SQL / MySQL
  2. User Permission
  3. Permission

Show Permission

 
/*
mysql> SHOW GRANTS FOR Joe@localhost;
+------------------------------------------------------------------------------------------------------------+
| Grants for Joe@localhost                             |
+------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'Joe'@'localhost' IDENTIFIED BY PASSWORD '*7341326DDB2391ED58CB4264AA085F5BF2F8B185' |
| GRANT SELECT ON `databasename`.* TO 'Joe'@'localhost'                             |
+------------------------------------------------------------------------------------------------------------+
2 rows in set (0.05 sec)


*/  
SHOW GRANTS FOR Joe@localhost;








Related examples in the same category

1.Use SELECT statements to see how the user account would be added to the user and db tables
2.Use SELECT statements to retrieve data from the user, tables_priv, and columns_priv tables