MySQL Forums
Forum List  »  Optimizer & Parser

is there a way to block backup privileges
Posted by: Raymond Davis
Date: December 27, 2007 10:40AM

I need to grant SELECT,UPDATE,DELETE,INSERT to a group of users however I would like to prevent the ability to backup or export the database. Is there a way to accomplish this in MySQL? I dont think max_queries_per_hour will work because I would need to set the number high enough to be functional say 1000 which would be greater then the number of tables in the DB. Perhaps there is a way to limit the number of results a user can get from a single query?

Options: ReplyQuote


Subject
Views
Written By
Posted
is there a way to block backup privileges
3426
December 27, 2007 10:40AM


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.