Hello Vlad,

Thank you for your swift reply.

>> I’ve got build 30793 of Firebird 3, zip file. Unzipped it,
>> started with –a –p as an application.
>
>    By default, shared database access is ON (i.e. SS mode in the engine is 
> ON).
>Without switch -m you started listener which will launch processes for 
>every attachment
>(i.e. CS mode in the remote server is ON).

OK.

>I don't know why do you specify switch -p (port name\number) without its 
>parameter.
>I guess you wish to run SS as application and to do it you need to specify 
>switches -a -m

It has a port number after the switch.

>    To add user into security db you don't need to run server at all, gsec 
> will work with
>embedded access to security db.

OK.

>> Trying to add a user to the security database via gsec,
>> but I get the following:
>>
>> C:\Program Files\Firebird\Firebird_3_0>gsec -add SYSDBA -pass masterkey
>> An error occurred while attempting to add the user.
>> no permission for insert/write access to TABLE USERS
>
>    -pass - specified password used to attach to database
>You need switch -pw, which specified password of user, which is -add'ed 
>or -mod'yfied:
>
>    gsec -add sysdba -pw masterkey

Oh, OK :)

Tried that, same error. Shut down the server and it works.

Thanks for the heads up!


With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!



------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT 
organizations don't have a clear picture of how application performance 
affects their revenue. With AppDynamics, you get 100% visibility into your 
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to