--
-- database-specific-grants.sql - Show grants specific to the databases
--
SELECT
	CONCAT("`", db.Db, "`") AS 'DATABASE',
	"ALL" AS 'TABLE',
	CONCAT("'", db.User, "'") AS 'USER',
	IF(db.Host = '%', 'ALL', CONCAT("'", db.Host, "'")) AS 'HOST',
	CONCAT(
		'GRANT ',
		CONCAT_WS(', ',
			IF(db.Select_priv = 'Y', 'SELECT', NULL),
			IF(db.Insert_priv = 'Y', 'INSERT', NULL),
			IF(db.Update_priv = 'Y', 'UPDATE', NULL),
			IF(db.Delete_priv = 'Y', 'DELETE', NULL),
			IF(db.Create_priv = 'Y', 'CREATE', NULL),
			IF(db.Drop_priv = 'Y', 'DROP', NULL),
			IF(db.Grant_priv = 'Y', 'GRANT', NULL),
			IF(db.References_priv = 'Y', 'REFERENCES', NULL),
			IF(db.Index_priv = 'Y', 'INDEX', NULL),
			IF(db.Alter_priv = 'Y', 'ALTER', NULL),
			IF(db.Create_tmp_table_priv = 'Y', 'CREATE TEMPORARY TABLES', NULL),
			IF(db.Lock_tables_priv = 'Y', 'LOCK TABLES', NULL),
			IF(db.Create_view_priv = 'Y', 'CREATE VIEW', NULL),
			IF(db.Show_view_priv = 'Y', 'SHOW VIEW', NULL),
			IF(db.Create_routine_priv = 'Y', 'CREATE ROUTINE', NULL),
			IF(db.Alter_routine_priv = 'Y', 'ALTER ROUTINE', NULL),
			IF(db.Execute_priv = 'Y', 'EXECUTE', NULL),
			IF(db.Event_priv = 'Y', 'EVENT', NULL),
			IF(db.Trigger_priv = 'Y', 'TRIGGER', NULL)
		), " ON `", db.Db, "`.* TO '", db.User, "'@'", db.Host, "';"
	) AS 'GRANT'
FROM
	mysql.db db
WHERE
	db.Db != '';