Changing a Role-Based User's Administrative Rights on a Role

Change a role-based user's ability to manage a role.

Prerequisites
Database Version Role-Based User Privileges
SAP Sybase IQ 15.3 and 15.4 Not supported.
SAP Sybase IQ 16.0 Requires one of:
  • Administrative rights over the role (role administrator).
  • MANAGE ROLES system privilege if the role has a global role administrator.
Task
  1. In the Perspective Resources view, select the resource and select Resource > Administration Console.
  2. In the left pane, select IQ Servers > Security > Role-Based > Users .
  3. Select a user from the right pane and either:
    • Click the arrow to the right of the name and select Manage Roles, or
    • From the Administration Console menu bar, select Resource > Manage Roles.
    A list of roles currently granted and their administrative rights appears.
  4. Highlight a role to be modified. Click in the Grant Options column, click the arrow, and select the administrative rights to be granted.
    Grant Option Description
    Role only (default) Grantee can use the underlying system privileges of the role only.
    Administrative only Grantee can grant and revoke the selected role to other users and roles, but cannot use its underlying system privileges.
    Administrative and role Grantee can grant and revoke the selected role to other users and roles and use its underlying system privileges.
  5. Click OK.
Parent topic: Role-Based Users
Related tasks
Creating a Role-Based User
Deleting a Role-Based User
Converting a Role-Based User to a User-Extended Role
Adding a Role to a Role-Based User
Removing a Role from a Role-Based User
Adding a System Privilege to a Role-Based User
Changing a User's Administrative Rights on a System Privilege
Removing a System Privilege from a Role-Based User
Viewing or Modifying Role-Based User Options
Generating Role-Based User DDL Commands
Viewing or Modifying Role-Based User Properties
Changing a Role-Based User Password
Forcing a Role-Based User to Change their Password
Unlocking a Role-Based User Account
Changing a Role-Based User Login Policy
Authenticating a Login Account for a Managed Resource
Related reference
Role-Based User Privilege Summary