That would grant the user select on everything in every database no matter what host they are coming from. He wants to only grant on specific tables, and did not mention anything about allowing from all hosts.
To answer the original question, I have tried a lot of different ways, but the only solution I have found is granting on the entire database or specifing each table in the tables_priv table. I go with the second option because although it is more work I like only allowing as much access as needed. The wild cards just don't seem to work in this instance. Has anybody had any success with it? -----Original Message----- From: Black, Kelly W [PCS] [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 11:14 AM To: 'Dimitar Haralanov'; [EMAIL PROTECTED] Subject: RE: granting privileges using wildcards I think this might do what you want, but then you will be required to log in with the -p syntax... GRANT SELECT on *.* TO yourlogin@'%' IDENTIFIED BY "somepassword"; FLUSH PRIVILEGES; mysql -u youruserid -p -h hostname dbasename Regards, Kelly Black Linux was very clearly the answer, but what was the question again? -----Original Message----- From: Dimitar Haralanov [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 11:03 AM To: [EMAIL PROTECTED] Subject: granting privileges using wildcards Hi, I have been trying to find information on the following question but have been unable to do so: Is it possible to grant options to a user using wildcards. For example: let's say that I have a database named 'db', and a user 'admin' who has full privileges. The user 'admin' will add and delete tables to 'db' but any table that is added/deleted will have the following name format 'table_[A-z0-9]'. What I would like to be able to do is grant select privileges to any and all of the tables 'table_*' to a user 'non_admin'. Is this possible and if it is, how can I do that? Thank you for your help! -- Mitko -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
