Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » User and database security » User security (roles and privileges) » Privileges

 

Revoking an object-level privilege (SQL)

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.

Prérequis

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.

 Task
  1. Connect to the database.

  2. Execute a REVOKE statement similar to the following:

    REVOKE privilege-name ON object-name FROM userid;

Résultat

The privilege is revoked from the specified user or role.

 See also