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.
Connect to the database.
Execute a REVOKE statement similar to the following:
REVOKE privilege-name ON object-name FROM userid;
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|