View System Privileges Granted to a Compatibility Role

Display a list of the system privileges granted to a compatibility role.

Prerequisites
Database Version Role-Based Compatibility Role Privileges
SAP Sybase IQ 15.3 and 15.4 Not supported.
SAP Sybase IQ 16.0 None.
Task
You cannot modify or remove the default underlying system privilege granted to a compatibility role, but you can add and remove additional system privileges.
  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 Compatibility Roles.
  3. Select a compatibility 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 granted to the compatibility role along with their corresponding grant option appears.
    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.
Related tasks
View Grantees of a Compatibility Role
View Underlying Roles Granted to a Compatibility Role
Adding a Grantee to a Compatibility Role
Changing a Grantee's Administrative Rights on a Compatibility Role
Removing a Grantee from a Compatibility Role
Deleting a Compatibility Role
Authenticating a Login Account for a Managed Resource
Related reference
Role-Based Compatibility Role Privilege Summary