How to grant privilege with wildcards ?
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 !
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.