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