Subject | create database if RESTRICT conf applied? |
---|---|
Author | mailmur |
Post date | 2006-11-16T21:11:35Z |
I have RESTRICT settings applied.
firebird.conf:
## Keep .fdb files in the folder
## c:/program files/firebird2/db/ folder
DatabaseAccess = Restrict db
If I use FlameRobin to create a new database and give database path
without explicit local folder structure:
test.fdb
-> "access to db "c:/program files/firebird2/bin/test.fdb" is denied..."
db\test.fdb
-> "access to db "c:/program files/firebird2/bin/db/test.fdb" is
denied..."
..\db\test.fdb
-> "access to db "c:/program
files/firebird2/bin/firebird2/db/test.fdb" is denied..." !!! look at
the folder server was about to use !!!
And using "aliases.conf" file it goes even more difficult to _remote_
administrate Firebird installation. I'd say its a rather impossible
and remotedesktop and/or VNC connection is mandatory with access to
server's local folder structure.
And then dbclients should know it even less, so aliases.conf is
mandatory. But then it must manually be edited.
How do you maintain server in a way that dbadmin and dbclients does
not need to know the physical folder structure?
How do you drop database?
I had no problems in MySQL and MSSQL server adminstration, but I find
this a problem in Firebird.
firebird.conf:
## Keep .fdb files in the folder
## c:/program files/firebird2/db/ folder
DatabaseAccess = Restrict db
If I use FlameRobin to create a new database and give database path
without explicit local folder structure:
test.fdb
-> "access to db "c:/program files/firebird2/bin/test.fdb" is denied..."
db\test.fdb
-> "access to db "c:/program files/firebird2/bin/db/test.fdb" is
denied..."
..\db\test.fdb
-> "access to db "c:/program
files/firebird2/bin/firebird2/db/test.fdb" is denied..." !!! look at
the folder server was about to use !!!
And using "aliases.conf" file it goes even more difficult to _remote_
administrate Firebird installation. I'd say its a rather impossible
and remotedesktop and/or VNC connection is mandatory with access to
server's local folder structure.
And then dbclients should know it even less, so aliases.conf is
mandatory. But then it must manually be edited.
How do you maintain server in a way that dbadmin and dbclients does
not need to know the physical folder structure?
How do you drop database?
I had no problems in MySQL and MSSQL server adminstration, but I find
this a problem in Firebird.