Subject Re: [firebird-support] Backup with admin rights is prohibited?
Author Thomas Steinmaurer
> 2016. 04. 22. 15:57 keltezéssel, Gabor Boros gaborboros@...
> [firebird-support] írta:
>> 2016. 04. 22. 15:37 keltezéssel, Dimitry Sibiryakov sd@...
>> [firebird-support] írta:
>>> 22.04.2016 15:34, Gabor Boros gaborboros@... [firebird-support] wrote:
>>>> 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".
>>>
>>> You forgot to mention role ADMIN in the command line.
>>
>> With "gbak -B -T -USER MYADMIN -ROLE RDB$ADMIN MYDB /home/user/MYDB.bak"
>> got the same error.
>
> Other idea?

Honestly, IMHO, if the user MYADMIN is a member of the RDB$ADMIN role in MYDB, then your gbak call should work.


--
With regards,
Thomas Steinmaurer
http://www.upscene.com

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.