Removing a Grantee from a Compatibility Role

Remove a user or role as a member (grantee) of a compatibility role. Grantees lose the ability to use any underlying system privileges or roles of the 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 You must have administrative rights over the compatibility role.
Task
  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 Grantees, or
    • From the Administration Console menu bar, select Resource > Manage Grantees.
      Warning!  When removing a grantee which is also a role, be sure you select the correct menu option. Each option has different inheritance outcomes. To review the differences, see Security Implications of the Managing Grantees and Managing Roles Options.
    A list of users and roles currently granted to the role appears.
  4. Highlight a user or role to be removed form the compatibility role and click Revoke.
    Note: The Revoke button is unavailable if you do not have administrative rights to the selected role.
  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 concepts
Security Implications of the Managing Grantees and Managing Roles Options
Related tasks
View Grantees of a Compatibility Role
View Underlying Roles Granted to a Compatibility Role
View System Privileges Granted to a Compatibility Role
Adding a Grantee to a Compatibility Role
Changing a Grantee's Administrative Rights on a Compatibility Role
Deleting a Compatibility Role
Authenticating a Login Account for a Managed Resource
Related reference
Role-Based Compatibility Role Privilege Summary