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: SAP Sybase IQ Authority and Privilege Reference
Related tasks
Adding a System Privilege to a Role-Based User
Adding a System Privilege to a User-Extended Role
Adding a System Privilege to a Standalone Role
Adding a System Privilege to a System Role
Adding an Authority to an Authority-Based User
Adding an Authority to a Group