Subject | Re: [ib-support] Privilege to Make Backup |
---|---|
Author | Helen Borrie |
Post date | 2002-08-29T00:15:22Z |
At 07:33 PM 28-08-02 -0300, you wrote:
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
>Hi,Only the sysdba user or the database owner can perform a database
>
>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.
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