Converting a User-Extended Role to a User

Change a user-extended role back to a regular user.

Prerequisites

Database Version	Role-Based User-Extended Role Privileges
SAP Sybase IQ 15.3 and 15.4	Not supported.
SAP Sybase IQ 16.0	You must have administrative rights over the role being converted.

Task

The user retains any login privileges, system privileges and roles granted to the user-extended role. The user remains as the owner of the objects that were created after the user was extended to act as a role. Any users granted to the user-extended role are immediately revoked.

A minimum number of role or global role administrators (as defined by the MIN_ROLE_ADMINS database option) with a login password must exist for each role at all times. When converting a user-extended role back to a user, all dependent roles of the user-extended role must continue to meet this minimum requirement, or the conversion fails.

In the Perspective Resources view, select the resource, and select Resource > Administration Console.
In the left pane, expand IQ Servers > Security > Role-Based, and then select User-Extended Roles.
Select a role from the right pane and either:
- Click the arrow to the right of the name and select Change to User, or
- From the Administration Console menu bar, select Resource > Change to User.
Click Yes to confirm conversion.

Created November 21, 2013. Send feedback on this help topic to Technical Publications: pubs@sap.com