GRANT on all dbs except mysql?
Posted by: rob
Date: June 17, 2005 09:54AM

Is there any way to grant privs for a particular user on all databases *except* the mysql database? That is, without having to run another GRANT for each database as it is added?

This would very useful for a generic application user that needs to work on many databases, but obviously shouldn't be able to access the mysql db.

Options: ReplyQuote


Subject
Written By
Posted
GRANT on all dbs except mysql?
rob
June 17, 2005 09:54AM


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.