Subject | Create an explicit database owner or an admin is enough? |
---|---|
Author | Gabor Boros |
Post date | 2017-03-23T18:48:42Z |
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
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