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
