Re: [Firebird-devel] Firebird 3 Alpha, cannot add user to with gsec

[Martijn T. (U. Productions) <m.t...@up...>]

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!