Subject Re: [firebird-support] How to connect to the SECURITY2.FDB database?
Author Helen Borrie
At 03:03 PM 8/05/2011, you wrote:
>Hello everybody
>
>I had read in the documentation (http://www.firebirdfaq.org/faq19/) that
>with Firebird 2.5 I can now create, alter and drop users.
>
>However, I can not do that, neither with ISQL or my application.
>
>Why not?
>
>When in ISQL I write:
>CONNECT '..\SECURITY2.FDB' USER 'SYSDBA' PASSWORD 'MyPass';
>
>the message:
>Statement failed, SQLSTATE = 28000
>no permission for direct access to security database ..\SECURITY2.FDB
>
>appears. Same thing happens if I write the full path to the database.
>
>Do you know what the problem is?

Yep. You didn't read the documentation very well. You submit these statements when connected as sysdba or equivalent to a *user* database, not security2.fdb. You can do it while logged into employee.fdb, if you like.

You can't connect to security2.fdb *at all*.

./hb