Changing Administrative Rights on a System Role Granted Privilege

Change the administrative rights on a system privilege granted to a system role.

Prerequisites
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.
Task

You cannot change the administrative rights on the default underlying system privileges of a system role.

  1. In the Perspective Resources view, select the resource, and select Resource > Administration Console.
  2. In the left pane, expand IQ Servers > Security > Role-Based, and then select System Roles.
  3. Select a system role from the right pane and either:
    • Click the arrow to the right of the name and select Manage System Privileges, or
    • From the Administration Console menu bar, select Resource > Manage System Privileges.
    A list of system privileges currently granted to the system role appears.
  4. Highlight a system privilege to be modified. Click in the Grant Option column, click the arrow, and select the administrative rights to be granted.
    Grant Option Description
    Privilege only (default) Grantees can perform authorized tasks requiring the selected privilege, but cannot grant the system privilege to other users and roles.
    Administrative only Grantees can grant and revoke the selected system privilege to other users and roles, but cannot perform authorized tasks requiring the selected system privilege.
    Administrative and privilege Grantees can grant and revoke the selected system privilege to other users and roles and can perform authorized tasks requiring the selected system privilege.
  5. Do one of:
    • Click OK to update any changes to the database and exit the properties view.
    • Click Apply to update any changes to the database, but remain in the properties view.
    • Click Cancel to cancel any changes not updated to the database and exit the properties view.
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
Removing a System Privilege from a System Role
Authenticating a Login Account for a Managed Resource
Related reference
Role-Based System Role Privilege Summary