MySQL Forums
Forum List  »  Security

Drop database restriction
Posted by: priya ram
Date: August 10, 2018 03:28AM

I have used syntax "GRANT DROP ON databasename.* TO username" to give DROP access for all objects in the particular database. But the user is able to drop that particular database itself.

How to restrict the user to drop only the objects in a database and not the database itself?

Options: ReplyQuote


Subject
Views
Written By
Posted
Drop database restriction
1162
August 10, 2018 03:28AM
392
February 02, 2019 06: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.