MySQL Forums
Forum List  »  Newbie

How to grant privilege with wildcards ?
Posted by: Jérémie Bouillon
Date: April 27, 2005 12:59PM

Hi, I'm trying to do something and I'm not sure is this is possible. I would like to grant several privileges to specific users, based on wildcards, inside a database. (I'm using MySQL 4.1)

Let's say I have john and bob as user; DB as my database.

I would like to say to MySQL that john can do pretty whatever he wants, but only on db.john_* (that means, database DB, and any tables with a name starting with "john_"), and bob can do the same but only on db.bob_* and so on.

I can do that by hand, but I would like to allow for create and drop privileges, so that john can create whataver table he wish as long as they start with john_ (or any other string, doesn't matter).

Do you know if that's possible, and what syntax should I use ? After reading online manual I thought it was possible, but I must have got the syntax wrong..

Thanks a lot !

Options: ReplyQuote


Subject
Written By
Posted
How to grant privilege with wildcards ?
April 27, 2005 12:59PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.