Role-Based System Role Privilege Summary

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.

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 You must have the 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 – you must have the MANAGE ROLES system privilege.
To then add an underlying role – you must have 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 – you must have the MANAGE ROLES system privilege.
To then add an underlying role – you must have 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 You must have the 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 You must have the MANAGE ROLES system privilege along with administrative rights over the system privilege.
Parent topic: System Roles
Related tasks
View Grantees of a System Role
View Underlying Roles of a System Role
View System Privileges Granted to a System Role
Adding a Grantee to a System Role
Removing a Grantee from a System Role
Adding a Role to a System Role
Changing Administrative Rights on an Underlying Role of a System Role
Removing a Role from a System Role
Adding a System Privilege to a System Role
Changing Administrative Rights on a System Role Granted Privilege
Removing a System Privilege from a System Role