Bug #26042 SHOW GRANTS syntax additions
Submitted: 2 Feb 2007 20:05 Modified: 7 Oct 2008 14:00
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Backup Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[2 Feb 2007 20:05] Peter Gulutzan 
Description:
SHOW GRANTS and GRANT could have more clauses and do more things.

For example:
SHOW FULL GRANTS to show every grant for every user.
There is one row in the result set for every row
in every mysql privilege table.

For example:
GRANT [TIMESTAMP=timestamp] [GRANTOR=grantor] ...;
The TIMESTAMP= and GRANTOR= clauses appear immediately
after the word GRANT, before the list of privileges.
They exist so that column information in the mysql
privilege tables can be reproduced. 

How to repeat:
SHOW FULL GRANTS;
GRANT TIMESTAMP='2007-02-02 20:20:20' to jerry@localhost;
[7 Oct 2008 14:00] Peter Gulutzan 
Susanne,

I only wrote this "feature request" because Brian Aker ordered it.
I have closed it now. Thanks for noticing.

Peter Gulutzan