Remove administrative rights only from a granted table permission.
Prerequisites
| Database Version |
Database Object Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Requires one of:- DBA authority.
- PERMS ADMIN authority.
- You own the database object.
|
| SAP Sybase IQ
16.0 |
Requires one of:- MANAGE ANY OBJECT PRIVILEGE system privilege.
- You have administrative rights to the permission being
modified.
- You own the database object.
|
Task
The REVOKE command applies to the database
object permission itself, not to any administrative right granted on the permission.
Therefore, to remove the administrative right only and leave the database object
permission intact, do not use the Revoke button. Rather,
regrant the specific permission without administrative rights. Only the original
grantor can remove the administrative rights only from a granted permission. If
another grantor regrants the same permission without administrative rights, a new
permission without administrative rights is granted, but the original permission
with administrative rights remains and takes precedence over any other
non-administrative grants of the same permission to the same user or role. - In the Perspective Resources view, select the resource and
select .
- In the Administration Console, expand .
- 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 .
The Table Properties view appears.
- In the left pane, click Permissions.
- In the right pane, click Grant.
- On the Welcome page, indicate whether the
grantee is a user or role.
- Click Next.
- On the Grantees page, select the
grantee.
- Click Next.
- On the Permissions page, select the
permissions from which the administrative rights are being revoked.
- Click Finish.
- Click OK.