http://www.etsetb.upc.es/download/sources/dump_grants/
DESCRIPTION
This tool dumps the permissions granted to the users of the MySQL
database. It also could print a report of dangerous grants.
USAGE
Dump Grants will retrieve the permissions granted as sql commands
and will store it in a flat file. The name of the file will have
the week day, so historic versions of the permissions can be kept.
ARGS
--help : This text
--version : Prints the version of the tool
--hostname : DataBase Server Hostname
--backup-dir : Directory where the grants will be stored
If it's - the output is the STANDARD OUTPUT
--check-domain : Checks the trailing string of the hostname
--nodump : Won't store the data. The grants will be only checked.
STORING
In the backup directory there will be stored the grants. It will keep
one week of data like this:
mon_grants.sql
tue_grants.sql
...
CHECK DOMAIN
This is a feature not related to dumping the database, but to check
the domain of the grants.
The way to do it is like this:
$ dump_grants --host=SERVERNAME --check-domain=.My.Domain
REVOKE USAGE ON big.* FROM 'annmarie'@'%';
REVOKE USAGE ON *.* FROM 'root'@'horta';
The standard error will report the revokes suggested.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw