To remove permissions previously granted to a user, use Sybase Central or the revoke command.
The syntax for the revoke command is:
revoke {sa | create object | primary subscribe |
connect source}
from user
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
