Remove administrative rights only from a permission granted to a user, user-extended
role, or standalone role on a view or materialized view.
Prerequisites
Database Version |
Role-Based Database Object
Privileges |
SAP Sybase IQ 15.3 and 15.4 |
Not supported. |
SAP Sybase IQ
16.0 |
You must
have 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, expand , and then select Users,
User-Extended Roles, or Standalone
Roles.
- Select a user, user-extended role, or standalone role in the right pane
either:
- 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.
- Click the drop-down
arrow and select
Views.
A list of permissions currently
granted to
Views appears.
- In the right pane, click Grant.
- Select Views and click Next.
- On the Objects page, select the view or
materialized view on which the administrative rights on a permissible are
being removed. Click Next.
- On the Permissions page, select the
permissions from which the administrative rights are being revoked.
- Click Finish to close the permissions
wizard.
- Do one of:
- Click OK to update any changes to the
database and exit the properties view.
- Click Cancel to cancel any changes not
updated to the database and exit the properties view.