Write a script that generates all the GRANT SQL ? Then pipe it into mysql.
I'd write a function that would go and get all the table name and a list of the relevant users then generate the sql from there. Jerry --------------------- Jeremy Hutchings Apps R&D Cable and Wireless --------------------- ----- Original Message ----- From: "Andrew Braithwaite" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 12, 2003 4:13 PM Subject: RE: mysql privs table level security > Any idea at all, anyone? > > Cheers, > > Andrew > > -----Original Message----- > From: Andrew Braithwaite > Sent: 11 February 2003 17:52 > To: [EMAIL PROTECTED] > Subject: mysql privs table level security > > > Hi all, > > Can anyone help me please? > > I have a database with hundreds of tables and I want to lock down certain > tables for select only. > > The order of presidence for mysql privs as far as I can tell is that if > there are database level privileges, these override the table level privs. I > don't want to have to issue a grant for each of the tables in the db - but > only wish to specify which tables need to be read only. > > I could go into the datadir and chmod 440 the files in question, but this > would deny write privs to all users wheras I would like certain users to > have write access. > > Any ideas? > > Cheers, > > Andrew > > Sql,query > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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