Subject Backup with admin rights is prohibited?
Author Gabor Boros
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