Converting a Role-Based User to a User-Extended Role

Change an existing user to act as a role. The user-extended role retains membership roles already granted to the user.

Prerequisites
Database Version Role-Based User Privileges
SAP Sybase IQ 15.3 and 15.4 Not supported.
SAP Sybase IQ 16.0 Requires MANAGE ROLES system privilege.
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 Change to Role, or
    • From the Administration Console menu bar, select Resource > Change to Role.
  4. Click Yes to confirm conversion.
After converting the user, if any of the following roles were granted to the original user, the underlying system privileges and roles are automatically inherited by any users added to the role. This can be prevented, for these roles only, by changing the administrative rights on the role along with the no inheritance option.
Parent topic: Role-Based Users
Related tasks
Creating a Role-Based User
Deleting a Role-Based User
Adding a Role to a Role-Based User
Changing a Role-Based User's Administrative Rights on a Role
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
Changing Administrative Rights on an Underlying Role of a User-Extended Role
Related reference
Role-Based User Privilege Summary