Revoke Permissions

Use Sybase Central or or the revoke command to remove permissions previously granted to a user.

The syntax for the revoke command is:

revoke {sa | create object | primary subscribe |
 connect source}
 from user

Note: You cannot revoke the sa permission from, or drop, the sa login name. This ensures that Replication Server is never without a replication system administrator.

The four permissions are managed independently. They can be granted and revoked in any order and the result is the same.

The following revoke command prevents user “louise,” who does not have sa permission, from creating replication definitions:

revoke create object from louise