Subject Create an explicit database owner or an admin is enough?
Author Gabor Boros
Hi All,


When I create a new database with 3.0 and want the security database in
the database itself follow the next steps:


isql -user SYSDBA employee


CREATE USER MYOWNER PASSWORD 'ooo' GRANT ADMIN ROLE;


isql -user MYOWNER employee


CREATE DATABASE 'MYDB' ...


isql -user MYOWNER MYDB


CREATE USER MYADMIN PASSWORD 'aaa' GRANT ADMIN ROLE;


At this point can connect to MYDB without an existing security3.fdb.


isql -user MYADMIN MYDB -role 'RDB$ADMIN'


Is it a good or bad practice to create an explicit owner?
For example with my practice (no security3.fdb) before restore the
database creation of MYOWNER needed.
Any difference between an owner and a user with admin role?


Gabor