Subject Re: [firebird-support] How to connect to the SECURITY2.FDB database?
Author W O
Ok Helen, thank you very much.

Walter.



On Sun, May 8, 2011 at 4:15 AM, Helen Borrie <helebor@...> wrote:

>
>
> 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
>
>
>


[Non-text portions of this message have been removed]