I think you need to give "reference" previliages also.
Frankly I never used it, so please correct me if I am wrong.
Rajeev
----- Original Message -----
From: "Peter Goggin" <pgoggin@stripped>
To: <win32@stripped>
Sent: Friday, July 05, 2002 1:43 PM
Subject: Re: Table privileges
> I have a table for which I want a particular user to be able to insert a
> complete row, but only be able to select two columns.
>
> I granted the follwoing:
> GRANT INSERT
> ON stamps.customers
> TO reguser@'%'
> IDENTIFIED BY 'regpassword';
> GRANT SELECT (customer_id, user_name)
> ON stamps.customers
> TO reguser@'%';
>
>
> If I log on as the user and select customer_id, user_name from customers
> then the query works.
> i.e
> select customer_id, user_name from customers;
>
> returns the two fields for every row in the table.
> If I qualify the query
> select customer_id, user_name from customers where user_name = 'username';
> the query fails with Error 1142 Select command denied to users
> 'reguser@localhost' for table 'customers'
>
> What else do I need to grant to make this work?
>
>
>
> Regards
>
> Peter Goggin
>
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail win32-thread9168@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail win32-unsubscribe@stripped instead.
>
>
>
