At 11:26 AM -0400 5/3/01, David C. Troy wrote:
>Hi, List!
>
>I have a table. The table has columns A, B, and C.
>
>I want User1 to be able to read columns A,B, and C, but I want User2 to
>only be able to read column A.
>
>Is this possible using MySQL columns_priv security?
Yes, use the GRANT statement. Something like this:
GRANT SELECT (A,B,C) ON db_name.tbl_name TO user1@host ...
GRANT SELECT (B) ON db_name.tbl_name TO user2@host ...
>
>Thanks,
>Dave
>
>=====================================================================
>David C. Troy [[EMAIL PROTECTED]] 410-544-6193 Sales
>ToadNet - Want to go fast? 410-544-1329 FAX
>570 Ritchie Highway, Severna Park, MD 21146-2925 www.toad.net
--
Paul DuBois, [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php