I have totally different task. I don't want to give users any other privileges but SELECT. But because I use MERGE tables for showing reports to users I must give for these tables UPDATE and DELETE privileges. And here I am talking about several hundreds tables for each user. MySQL doesn't have wild cards for table name field in tables_priv. Otherwise it would be very easy: GRANT ... ON db.ab% for user. The only way I see now is to set privileges for each table for each User manually (I mean script). Do you know any other way?
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 10:14 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: How to set permissions? This might not be the best way, but for the people here at my office who aren't familiar with command line interfaces, I've setup MyODBC and MS Access. This let's them add/edit user's account info directly. The only thing you can't do (afaik), is change a user's password. -- Mike Miller -- [EMAIL PROTECTED] -----Original Message----- From: Yana [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 10:01 AM To: [EMAIL PROTECTED] Subject: RE: How to set permissions? Helo! Is there any other way to set permissions to the list of tables in mysql db (big list!) with similar names (f.e. c%), then running a script on it? Thanks --------------------------------------------------------------------- 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
