Granting SYS_AUTH_BACKUP

Allows users to perform all backups.

Prerequisites

Administrative privilege over SYS_AUTH_BACKUP_ROLE.

Task

You can grant this role with or without administrative rights. When granted with administrative rights, you can manage (grant and revoke) the role, as well as use any of the underlying system privileges. When granted with administrative rights only, you can manage the role, but not use its underlying system privileges. Finally, when granted with no administrative rights, you can only use its underlying system privileges.

Note: When migrating from SAP Sybase IQ 15.4 and earlier, the concept of inheritance of the underlying system privileges of this system role represents a change in behavior in SAP Sybase IQ 16.0 or later. For SAP Sybase IQ 15.4 and earlier behavior, use the WITH NO SYSTEM PRIVILEGE INHERITANCE clause.

The WITH ADMIN ONLY OPTION and WITH ADMIN OPTION clauses are invalid when using the WITH NO SYSTEM PRIVILEGE INHERITANCE clause. The WITH NO ADMIN OPTION clause is valid, but not required, as it is semantically equivalent to the WITH NO SYSTEM PRIVILEGE INHERITANCE clause.

To grant the SYS_AUTH_BACKUP_ROLE role, execute one of the following statements:

Administrative Option	Statement
With full administrative rights	GRANT ROLE SYS_AUTH_BACKUP_ROLE TO `user_ID` WITH ADMIN OPTION
With administrative rights only	GRANT ROLE SYS_AUTH_BACKUP_ROLE TO `user_ID` WITH ADMIN ONLY OPTION
With no administrative rights	GRANT ROLE SYS_AUTH_BACKUP_ROLE TO `user_ID` WITH NO ADMIN OPTION
With no system privilege inheritance	GRANT ROLE SYS_AUTH_BACKUP_ROLE TO `user_ID` WITH NO SYSTEM PRIVILEGE INHERITANCE

Example:

This example grants the SYS_AUTH_BACKUP_ROLE to Mary with administrative rights and inheritance of the underlying system privileges of the role.

GRANT ROLE SYS_AUTH_BACKUP_ROLE TO Mary WITH ADMIN OPTION

This example grants the SYS_AUTH_BACKUP_ROLE to Joe with neither administrative rights nor inheritance of the roles underlying system privileges.

GRANT ROLE SYS_AUTH_BACKUP_ROLE TO Joe 
WITH NO SYSTEM PRIVILEGE INHERITANCE

Granting SYS_AUTH_BACKUP_ROLE