Subject | Granting Create Database via client api |
---|---|
Author | |
Post date | 2019-04-18T05:03:16Z |
With the advent of Firebird 3
Users who create databases must be given that permission by SYSDBA.
However even to call the command ( listed below ) it seems you must already have a working connection to a database you cannot create using a client connection from another computer.database.
How do we get around this catch 22.
ie. In order to create a database in Firebird 3 by a non SYSDBA user, a connection must be made and the CREATE DATABASE privilege must be granted. But on a clean firebird system there is no database to connect to.
How do you call:
GRANT CREATE DATABASE TO USER
without actually having a database connection