Subject Re: [ib-support] How do I change user name and pasword?
Author Helen Borrie
At 07:01 AM 9/06/2003 -0500, you wrote:
>Greetings All,
>I have always used the default user name (SYSDBA) and password (masterkey)
>for my database. Now I would like to change this to use our user name and
>password. How do I change them for a production database? Any pointers

Users and their passwords pertain to the server, not to individual
databases. Every server has to have a SYSDBA. You can (and should) change
its password.

SYSDBA has all rights on all databases. Another user will also have all
rights to any database which that user owns, or to any database to which
SYSDBA (or the owner) grants it privileges for. No other users have any
rights to any databases unless the owner, SYSDBA ,or another user who has
been grant GRANT rights, grants them privileges (of various sorts) to each

You can add and modify users using the gsec program. Instructions for
using gsec are in the OpGuide. The program itself is in the bin directory
under your firebird root. Most GUI admin tools have an interface to gsec.

SYSDBA or owner, etc. grants rights generally by running a grant script -
just a regular DDL script consisting of all the required GRANT statements.