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;
Discuter à propos de cette page dans DocCommentXchange.
|Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0|