Is there a reason for not using tables_priv table for this purpose?
Mihail ----- Original Message ----- From: "Dimitar Haralanov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 26, 2003 2:29 PM Subject: Re: granting privileges using wildcards On Wed, 26 Mar 2003 13:14:09 -0600 Black, Kelly W [PCS] wrote: > 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 Well, as far as I know SQL and MySQL this will grant select option to user 'yourlogin' from any host to any database and any table. What I wanted is that the user will have select privileges on on tables 'table_*' from database db. Basically, is something like the following possible? GRANT SELECT ON db.table_% TO user@'%' IDENTIFIED BY 'pass'; Thanx -- Mitko -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]