>>Even though my new user is the owner, I don't have sufficient rights to
>>access the tables. How can I grant these rights to my new user?
>
> You *could* log in as sysdba and grant all of the necessary privileges to
> that user, including WITH GRANT OPTION if necessary. But it's not ideal.
> As I and several others have already explained, recreate and pump is the
> proper solution.

I did recreate the database however with the new user, using gbak. Is that
not sufficient? If not, can you suggest a tool to recreate and pump the
database? There are only 4 actual records in the database initially.

>>2) Do you connect to the database using sysdba / masterkey, or do you
>>connect using a new owner user you created?
>
> I deploy a security.fdb with the needed user(s) for getting started.

But won't that overwrite their existing security.fdb, if they already have
Firebird installed, or are you talking about situations where they
definitely do not have it installed? If they do not have it installed, can I
just copy my security.fdb file (with users set as I want them) and get the
user to copy it into the appropriate folder after they install Firebird?

>>3) How do you get the end-user to create the Firebird username/password
>>required to access the database?
>
> By providing a utility program and the initial sysdba password.

What does the utility program do? If you supply the security.fdb file, then
the user does not need to create the Firebird username/password required,
correct?

Out of interest, off topic slightly, but what software development tool do
you use (and are others using)? I am using Delphi. Just curious.

Thanks,
Stephen