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 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 >dbEngine.BatchControlMaster TO test3kwh IDENTIFIED BY 'stinky'; > >And I get back: > >ERROR 1064: You have an error in your SQL syntax near '(BatchControlUri, >IndustryId, UpdateId) on dbEngine.BatchControlMaster TO test3k' at line 1 > >I have tried several variation on this theme but can't find the magic to do >column level security. > >TIA! > >Ken Hylton > > > > >--------------------------------------------------------------------- >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 > --------------------------------------------------------------------- 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