Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 10.0.1 » SQL Remote » SQL Remote Administration » Managing SQL Remote permissions » Granting and revoking REMOTE and CONSOLIDATE permissions

Granting CONSOLIDATE permissions Next Page

Revoking REMOTE and CONSOLIDATE permissions

A user can be removed from a SQL Remote installation by revoking their REMOTE permissions. When you revoke remote permissions from a user or group, you revert that user or group to a normal user/group. You also automatically unsubscribe that user or group from all publications.

Revoking permissions from Sybase Central

You can revoke REMOTE permissions on SQL Anywhere databases from Sybase Central.

To revoke REMOTE permissions (Sybase Central)

  1. Open either the Users & Groups folder or the SQL Remote Users folder.

  2. Right-click the remote user or group and choose Revoke Remote from the popup menu.

    3. Revoking permissions

    REMOTE and CONSOLIDATE permissions can be revoked from a user using the REVOKE statement. The following statement revokes REMOTE permission from user S_Beaulieu.

    REVOKE REMOTE FROM S_Beaulieu

    DBA authority is required to revoke REMOTE or CONSOLIDATE access.