Details
-
Technical task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
None
-
None
Description
Many web application administration GUIs will not have superuser OS command line access for security reasons. Particularly those written in PHP. For those users we need an SQL way to create/drop Catalogs.
Whilst we have an SQL command for drop Catalog, the one for "CREATE CATALOG" does not handle the authentication tables, and are unlikely to exist in its current form in the end product.
A UDF will be created which will require the user to be a super user in the `def` Catalog that will allow the creation of a new Catalog, applying all relevant system tables.
Attachments
Activity
Attempted to build this using stored procedures instead. But "USE" is blocked, so we cannot switch catalog. Also, we cannot use CREATE TABLE LIKE for cross-catalog (for good reason). So this is not possible.
This is seemingly impossible. Whilst `mariadb-install-db` needs to run as a user privileged enough to write to the MariaDB datadir (and this is fine), it also needs to run with superuser privilege on the `def` Catalog. This is only possible if that user doesn't have a password, or things are made very insecure.