Bug #1286 Reference manual doesn't define GRANT/REVOKE privileges

• Submitted: 15 Sep 2003 18:02
• Modified: 17 Sep 2003 9:47
• Reporter: [ name withheld ]
• Status: Closed
• Category: MySQLCC: Docs
• Severity: S3 (Non-critical)
• Version: 3.23.51
• OS: n/a
• CPU Architecture: Any

[15 Sep 2003 18:02] [ name withheld ]

Description:
In the MySQL Reference Manual, section 4.3.1 does not document 
the meaning of all the priv_type options.  (Of the 15 options, 
only 3 are actually defined.)

Although many meanings seem intuitively obvious, they should be
documented.  For example, does the SELECT privilege on a table
refer to selecting rows based on the column (e.g., in a WHERE
clause) or to selecting the column, or just to any use in a
SELECT statement?  

I would guess it's the latter, but the user (once who's actually 
Reading The F(ine) Manual) shouldn't have to guess.

How to repeat:
 

Suggested fix:
Make sure the semantics of each syntactic option is specified.

Many options can probably be covered with one statement roughly
like "privileges X, Y, and Z allow use of the associated table or
column in SQL X, Y, or Z statements, respectively."

[17 Sep 2003 9:47] Paul DuBois

GRANT privileges are described in the section
that shows the syntax for the GRANT statement:

http://www.mysql.com/doc/en/GRANT.html

Other information may be found here as well:

http://www.mysql.com/doc/en/Privileges_provided.html

You mentioned also that the scope of each privilege
should be stated. This depends on the level at which
you grant a privilege, as discussed in the GRANT
statement section.

[17 Sep 2003 10:07] [ name withheld ]

Okay, it looks like the problem has been fixed since 3.23.51.