----- Original Message -----
From: "Helen Borrie" <helebor@...>
>>But, I can still connect to this new database using SYSDBA/masterkey
>>credential. Am I missing anything?
>
> Yes, you've missed the point that SYSDBA has full destructive rights to
> ALL databases on the server. The Owner has similar rights only to the
> database it owns (but it can't operate on the security database: only
> SYSDBA can do that.)
> And you might also have missed the point that the database owner doesn't
> have any privileges to any objects that were created by another user,
> including SYSDBA - SO MAKE SURE YOU LOG IN AS OWNER WHEN YOU CREATE OR
> ALTER OBJECTS !!
But how do you create the new user (the owner user) when you deploy an
application to someone who installs Firebird for the first time in order to
be able to use your application?
Also, how do I change the owner of my existing database to make it ready for
deployment? I have a near-empty version of my database (just 3 or 4 records
in it). Do you need to recreate it or can you use something like IB_SQL to
do it?