Add users or roles to a system privilege grant list.
Prerequisites
Database Version
Role-Based System Privilege Privileges
SAP Sybase IQ 15.3 and 15.4
Not supported.
SAP Sybase IQ
16.0
Requires administrative rights over any 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, select IQ Servers > Security > Role Based > System Privileges.
Select a system privilege 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.
A list of users and roles currently granted the system privilege
appears.
Click Grant.
Select one or more users or roles.
Tip: Use Shift-click or
Control-click to select multiple users or roles.
Click OK.
The new grantees appear granted with
Privilege only rights (no administrative
rights).
Optional) To modify the administrative rights, highlight a grantee. 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.