Adding a System Privilege to a Role-Based User

Allows a role-based user to perform privileged tasks associated with a system privilege.

Prerequisites

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

The SAP Sybase IQ resource is authenticated and running.
The selected resource supports role-based security

Task

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 Users.
Select a user 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 currently granted to the user appears.
Click Grant.
Select one or more system privileges to grant. Only system privileges to which you have administrative rights appear on the list.

Tip: Use Shift-click or Control-click to select multiple system privilege.
Click OK to grant the system privileges.
The selected system privileges appear granted with Privilege only rights (no administrative rights).

(Optional) To modify the administrative rights of a system privilege, highlight a system privilege. Click in the Grant Options column, click the arrow, and select the administrative rights to be granted.

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.

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.