Subject | Backup with admin rights is prohibited? |
---|---|
Author | Gabor Boros |
Post date | 2016-04-22T13:34:21Z |
Hi All,
I have a 3.0 database with self security database. Use an admin user
(CREATE USER MYADMIN PASSWORD 'mypassword' GRANT ADMIN ROLE;) for daily
admin work without any problem. Now tried to do a backup (gbak -B -T
-USER MYADMIN MYDB /home/user/MYDB.bak) and gbak say "You must be either
SYSDBA or owner of the database". But with SYSDBA (gbak -B -T -USER
SYSDBA MYDB /home/user/MYDB.bak) the backup created successfully. This
is very strange. Because the database created with MYOWNER user (and
SELECT DISTINCT RDB$OWNER_NAME AS DATABASE_OWNER FROM RDB$RELATIONS
WHERE (RDB$SYSTEM_FLAG = 1) give back MYOWNER correctly) and SYSDBA not
exist anywhere(security3.fdb deleted after install).
Gabor
I have a 3.0 database with self security database. Use an admin user
(CREATE USER MYADMIN PASSWORD 'mypassword' GRANT ADMIN ROLE;) for daily
admin work without any problem. Now tried to do a backup (gbak -B -T
-USER MYADMIN MYDB /home/user/MYDB.bak) and gbak say "You must be either
SYSDBA or owner of the database". But with SYSDBA (gbak -B -T -USER
SYSDBA MYDB /home/user/MYDB.bak) the backup created successfully. This
is very strange. Because the database created with MYOWNER user (and
SELECT DISTINCT RDB$OWNER_NAME AS DATABASE_OWNER FROM RDB$RELATIONS
WHERE (RDB$SYSTEM_FLAG = 1) give back MYOWNER correctly) and SYSDBA not
exist anywhere(security3.fdb deleted after install).
Gabor