Subject Re: [ib-support] Privilege to Make Backup
Author Helen Borrie
At 07:33 PM 28-08-02 -0300, you wrote:
>Hi,
>
>How can I give privilege for a user only to execute the backup of databases?
>
>I am using Interbase6.0 and the Backup are made from the ISQL.

Only the sysdba user or the database owner can perform a database
backup. It is not a privilege that can be given to another user.

Any user can restore a database from the backup file, as long as the
-create option is used. One option available would be to create a user for
the purpose of backup and to have that user restore a backup using
-create. That user would then become the owner of the copy, which you
could substitute for the original database. (one more security exploit
unveiled!!)

Actually, it is not possible to make a backup from ISQL. The backup
utility is a separate program named gbak.

heLen