Grant and Revoke in mySQL

[Hal Duston]

On Tue, 2003-04-15 at 16:33, Chris Wagner wrote:
> Can someone help me understand these things a bit better?
> 
> I'm trying to read through the docs on the mySQL site and it's a bit
> more than I'm used to, at least not in plainer English.

I don't know mySQL, but I've used Oracle for years.

> Here's a snip that I was reading.
> 
> Can someone help me dissect this?

The items listed in square brackets are optional.
The items listed in curly braces, you must choose one of.

> GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...]
> What exactly is the column_list, and what should more properly be
> inserted here?

The column list is optional and defaults to the entire table.
> 
>     ON {tbl_name | * | *.* | db_name.*}
> I think I understand this line, granted I have a db and table name to
> provide.
> 
>     TO user_name [IDENTIFIED BY [PASSWORD] 'password']
> Do I just create a username and password of choice here?

The user you want to be able to access the table (columns)

>         [, user_name [IDENTIFIED BY 'password'] ...]
> Assuming I'm filling based on previous line.....

No, specifying a second user to grant to.  The `...' indicates the place
for additional ones.

--snip--

> REVOKE priv_type [(column_list)] [, priv_type [(column_list)] ...]
>     ON {tbl_name | * | *.* | db_name.*}
>     FROM user_name [, user_name ...]
> So is REVOKE strictly to prohibit users?

This is for removing GRANT's yes.

> Thanks,
> 
> Chris

Hal