Revoke an object-level privilege that has been granted to a user or role to restrict access to a specific object, such as a table, view, procedure, sequence, or dbspace.
To revoke an object-level privilege, one of the following must be true:
You are the owner of the database object you are revoking privileges for.
You have been granted the privilege and have administrative rights on it.
You have the MANAGE ANY OBJECT PRIVILEGE system privilege.
In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
In the left pane, either click the database object that you want to revoke a user privilege from, or click Users or Roles and click the user or role that you want to revoke privileges from.
|Revoke an object-level privilege per user or role||
|Revoke an object-level privilege per database object||
Click File » Save.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|