A list of the system privileges and object permissions
required to complete the various
role-based system role tasks.
View Grantees, Underlying Roles, and System Privileges Granted to a System Role
| Database Version |
Role-Based System Role Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Not supported. |
| SAP Sybase IQ
16.0 |
None required. |
Adding and Removing Grantees to and from a System Role
| Database Version |
Role-Based System Role Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Not supported. |
| SAP Sybase IQ
16.0 |
Requires MANAGE ROLES system privilege. |
Adding and Removing Underlying Roles to and from a System Role
| Database Version |
Role-Based System Role Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Not supported. |
| SAP Sybase IQ
16.0 |
To enable the Manage Roles option requires the MANAGE ROLES
system privilege.To then add an underlying role requires one of: - Administrative rights over the underlying role (role
administrator).
- MANAGE ROLES system privilege if the underlying role has a
global role administrator.
|
Changing Administrative Rights of an Underlying Role on a System Role
| Database Version |
Role-Based System Role Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Not supported. |
| SAP Sybase IQ
16.0 |
To enable the Manage Roles option requires the MANAGE ROLES
system privilege.To then add an underlying role requires one of: - Administrative rights over the underlying role (role
administrator).
- MANAGE ROLES system privilege if the underlying role has a
global role administrator.
|
Adding and Removing System Privileges from a System Role
| Database Version |
Role-Based System Role Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Not supported. |
| SAP Sybase IQ
16.0 |
Requires MANAGE ROLES system privilege along with administrative rights over the system
privilege. |
Changing Administrative Rights of an Underlying Role on a System Role
| Database Version |
Role-Based System Role Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Not supported. |
| SAP Sybase IQ
16.0 |
Requires MANAGE ROLES system privilege along with administrative rights over the system
privilege. |