The Sybase agent requires two user accounts to access the Sybase application and database to perform backup and restore operations:
-
Database user account with administrator privileges.
On Unix computers, the account information for accessing the database is provided during the Sybase iDataAgent installation.
On Windows computers, the account information is provided during the instance configuration after the installation of the Agent.
-
Operating system account with privileges to access the Sybase application.
The following table illustrates the required user account privileges for backup and restore operations:
|
Operations |
User Account Needed |
|
Create Sybase server |
Sybase database administrator account (SA role) |
|
Backup Sybase database and Restore non-system databases |
Operating system user account (operator role) with access to all the databases in an instance. |
|
Restore Sybase system databases |
Sybase database administrator account (SA role) |