Saari Development

This blog is intended to be a log of my (Ali Rizvi's) professional ramblings as a software development engineer. I intend to add logs of my experience with different technologies, software, tech books/articles and related stuff from time to time. My intention is to have an archive for my personal use and public benefit.

Saturday, December 10, 2005

MySQL: Display permissions on different databases

mysql> select Host, DB, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Alter_priv from db;


+-----------+-------------------+-------+-------------+-------------+-------------+-------------+-------------+-----------+------------+
| Host | DB | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Alter_priv |
+-----------+-------------------+-------+-------------+-------------+-------------+-------------+-------------+-----------+------------+
| % | test | | Y | Y | Y | Y | Y | Y | Y |
| % | test\_% | | Y | Y | Y | Y | Y | Y | Y |
| localhost | depot_development | rizvi | Y | Y | Y | Y | Y | Y | Y |
| localhost | depot_production | rizvi | Y | Y | Y | Y | Y | Y | Y |
| localhost | depot_test | rizvi | Y | Y | Y | Y | Y | Y | Y |
| localhost | depot_production | prod | Y | Y | Y | Y | Y | Y | Y |
+-----------+-------------------+-------+-------------+-------------+-------------+-------------+-------------+-----------+------------+

0 Comments:

Post a Comment

<< Home