[MDEV-8005] Disallowing DROP DATABASE via privileges Created: 2015-04-17  Updated: 2017-06-01

Status: Open
Project: MariaDB Server
Component/s: Admin statements, Authentication and Privilege System
Fix Version/s: None

Type: Task Priority: Major
Reporter: Cloud Foundry Core Services team Assignee: Unassigned
Resolution: Unresolved Votes: 2
Labels: None


 Description   

At the moment, there is no separation between DROP TABLE and DROP DATABASE.

There is a mysql bug from 2006 that captures this enhancement request: http://bugs.mysql.com/bug.php?id=18938

Similar to this bug report, in our use case, the DATABASE schemas are automatically created by our software. While multiple users may create and remove tables within that database, we would prefer to prevent them from dropping the entire database without using the Cloud Foundry mechanisms that were used to provision the database in the first place.

Without this restriction, we've had to make various parts of our software smarter, to not automatically assume that a database we've created always exists until our software has deleted it.


Generated at Thu Feb 08 07:23:56 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.