Subject Re: [firebird-support] Adding a user.
Author Helen Borrie
At 01:08 AM 9/04/2009, you wrote:
>Ok I just installed Firebird 2.1.2 on my Windows 2000 SP4 server.
>
>Everything went well and the service is started.
>
>I have now opened the command prompt CD to my bin directory and tried to add a user via the following steps.
>
>1) Open a command window - On Unix, you must su root
> 2) Run gsec by typeing in the following:
>
> Linux:
> /opt/firebird/bin/gsec
>
> Windows:
> gsec

Missing: log in as SYSDBA to add a user !!

So -

Linux:
/opt/firebird/bin/gsec <-- OK if you are su
otherwise
/opt/firebird/bin/gsec -user sysdba -password sdbpass

Windows:
gsec -user sysdba -password sdbpass


> 3) At the GSEC> prompt, type in the following:
>
> add plg -pw <password_for_new_user>

Won't work if you are not logged in as SYSDBA, i.e., you can't add yourself!

./heLen