You have administrative rights (with grant option) to the
permission.
You own the database object.
SAP Sybase IQ
16.0
Requires one of:
MANAGE ANY OBJECT PRIVILEGE system privilege.
You have administrative rights (with grant option) to the
permission.
You own the database object.
The
SAP Sybase IQ resource is authenticated and running.
In a multiplex configuration, the coordinator node is
running.
Task
In the Perspective Resources view, select the resource and
select Resource > Administration Console.
In the Administration Console, expand IQ Servers > Schema Objects > Tables.
Select Tables or Global Temporary
Tables.
Select a table from the right pane and either:
Click the arrow to the right of the name and select
Properties, or
From the Administration Console menu bar, select Resource > Properties.
The Table Properties view appears.
In the left pane, click Permissions.
In the right pane, click Grant.
The Grant Permission Wizard appears.
On the Welcome page, indicate whether the permission is being granted to a user or
role.
Click Next.
On the Grantees page, select one or more users or roles. Click the box in the header row to
select all available users or roles.
Click Next.
On the Columns page, select one or more columns for the selected table to apply the
permissions to. Click the box in the header row to select all available
columns.
Click Next.
On the Permissions page, select one or more permissions. Click the box in the header row to
select all available permissions.
(Optional) Click the With grant option to
grant the selected permissions administrative rights.
Note: The With grant option applies to all selected permissions.
You cannot apply the With grant option option to individual
permissions.