patternsqlMinor
Drop privilege to tables only, Not to database
Viewed 0 times
tablesprivilegedatabasedropnotonly
Problem
I created a user with drop privilege to a database.
How can I create a user who has the privilege to drop tables of a specified database, but not database.
How can I create a user who has the privilege to drop tables of a specified database, but not database.
Solution
Do
The MySQL Reference Manual is a great place to look for this kinds of things.
GRANT DROP ON TABLE thedatabase.* TO user1.The MySQL Reference Manual is a great place to look for this kinds of things.
Context
StackExchange Database Administrators Q#48510, answer score: 8
Revisions (0)
No revisions yet.