-- Collection of code snippets by Arne Vajhøj 
-- posted to eksperten.dk, usenet and other places (2002-now) 
GRANT SELECT ON test.t1 TO 'dennis'@'%' IDENTIFIED BY 'hemmeligt';
SHOW GRANTS FOR 'dennis'@'%';
REVOKE ALL PRIVILEGES ON test.t1 FROM 'dennis'@'%';
SHOW GRANTS FOR 'dennis'@'%';
DROP USER 'dennis'@'%';
SHOW GRANTS FOR 'dennis'@'%';
