Hi,

I am writing a client application which allows the user specify his
username and password.
My application then connect to the Firebird server using the SYSDBA
account and create that new user, after that will grant privilege to
this new user account.

I don't know can I use stored procedure to do that or can I use SQL to
do that.
The creation of the new user is a dynamic process so it must be done
by the application.


--- In firebird-support@yahoogroups.com, Milan Babuskov <milanb@...>
wrote:

>
> alanpltse wrote:
> > How do I create a user and grant privileges on a database files?
>
> You can use "gsec" tool from Firebird's "bin" directory, or use any
> admin tool like FlameRobin (Manage Users option in Server menu).
>
> If you're on Linux, it would be something like:
>
> gsec -database /opt/firebird/security.fdb -user sysdba -pass ***** -add
> NEWUSER -pw PASS_FOR_NEW_USER
>
>
> Only the user runing the server (typically user "firebird" on Linux)
> should have privilege on database files (this is done by chmod/chown
> commands). Each username you create automatically has the rights to
> connect to all databases. To grant rights on individual objects in
> database, use GRANT statements:
>
> GRANT SELECT ON EMPLOYEE TO NEW_USER;
> etc.
>
> --
> Milan Babuskov
> http://www.guacosoft.com
> http://www.flamerobin.org
>