Re: Column Privilege Question

2001-05-03 Thread Paul DuBois
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 sta

Column Privilege Question

2001-05-03 Thread David C. Troy
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? Thanks, Dave ===