Remove administrative rights only from a permission granted to a user, user-extended
role, or standalone role, on a table or column.
Prerequisites
| Database Version |
Role-Based Database Object
Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Not supported. |
| 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 left pane, select .
- Select:
- Users
- User-Extended Roles
- Standalone Roles
- Select:
- Click the arrow to the right of the name and select
Properties, or
- From the Administration Console menu bar, select .
- In the left pane, select Permissions.
- In the right pane, click Grant.
- On the Welcome page, based on the table level of the permission to be regranted,
select Tables or Table columns.
- Click Next.
- On the Permissions page, select the
permissions from which the administrative rights are being revoked.
- Click Finish.
- Click OK.