column level grants

2002-02-28 Thread Kenneth Hylton
Howdy - I have looked online and also in MySQL by Paul DuBois, plus the O'Reilly book and can't find an example of how to do column level security. We are running 3.23.46-Max on Red Hat 7.2 Here is what I am trying: mysql GRANT ALL (BatchControlUri, IndustryId, UpdateId) ON

Re: column level grants

2002-02-28 Thread Doug Thompson
You are restricted to SELECT, INSERT, and UPDATE privileges on columns. ALL won't work. Regards, Doug On Thu, 28 Feb 2002 11:31:15 -0600, Kenneth Hylton wrote: Howdy - I have looked online and also in MySQL by Paul DuBois, plus the O'Reilly book and can't find an example of how to do