Subject Re: [firebird-support] Creating users
Author Stefan Heymann
Hi Pepak,

> Is it possible to create users using SQL? I need to create an extra user
> from my database and so far it looks like I'll have to do it either manually
> or through an application. I would much prefer to cerate user through a
> database upgrade script, though.

It's not possible. Users are stored in a separate database
(security.fdb in the Firebird folder). This database will be not be
accessible via regular SQL connections from Firebird 2.0 on (the name
will be security2.fdb). Setting the password is also impossible via
regular SQL (this applies to 1.5).

So you must use an application. The simplest one is the GSEC
command line tool that comes together with Firebird.

Best Regards


Stefan Heymann