Contents Index Execution permissions of triggers Revoking user permissions

ASA Database Administration Guide
  Managing User IDs and Permissions
    Managing individual user IDs and permissions

Granting and revoking remote permissions


In Sybase Central, you can manage the remote permissions of both users and groups. Remote permissions allow normal users and groups to become remote users in a SQL Remote replication setup in order to exchange replication messages with the publishing database.

Granting remote permissions 

You cannot grant remote permissions to a user until you define at least one message type in the database.

To grant remote permissions to a group, you must explicitly grant remote permissions to each user in the group. You cannot grant remote permissions to a group itself.

Revoking remote permissions 

Revoking remote permissions reverts a remote user to a normal user. Revoking these permissions also automatically unsubscribes that user from all publications.

To grant remote permissions to users (Sybase Central)

  1. Connect to a database.

  2. Open the Users & Groups folder.

  3. Right-click the desired user and choose Change to Remote User from the popup menu.

  4. In the resulting dialog, enter the desired values.

Once you have granted remote permissions to a user, you can subscribe it to publications:

To revoke remote permissions from remote users

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

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

For more information, see SQL Remote Concepts.


Contents Index Execution permissions of triggers Revoking user permissions