Contents Index Granting CONSOLIDATE permissions Assigning permissions in multi-tier installations

SQL Remote User's Guide
  SQL Remote Administration
    Managing SQL Remote permissions
      Granting and revoking REMOTE and CONSOLIDATE permissions

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 Adaptive Server 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.

Revoking permissions in Adaptive Server Anywhere 

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.

Revoking permissions in Adaptive Server Enterprise 

REMOTE permissions can be revoked from a user using the sp_revoke_remote procedure. This procedure takes a single argument, which is the user ID of the user. The following statement revokes REMOTE permission from user S_Beaulieu.

exec sp_revoke_remote 'S_Beaulieu'
go

Contents Index Granting CONSOLIDATE permissions Assigning permissions in multi-tier installations