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 (Sybase Central)

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. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. 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.

    Option Action
    Revoke an object-level privilege per user or role
    1. In the right pane click the privileges tab that corresponds to the database object that you want to revoke privileges on. For example, to revoke privileges on a table, click the Table privileges tab.

    2. Right-click the privilege and click Revoke then either click All Privileges or the specific privilege you want to revoke.

    Revoke an object-level privilege per database object
    1. In the right pane click the Privileges tab.

    2. Right-click the user or role and click Revoke then either click All Privileges or the specific privilege you want to revoke.

  3. Click File » Save.

Résultat

The privilege is revoked from the specified user or role.

 See also