SQL Remote User's Guide
Command Reference for Adaptive Server Anywhere
Use this statement to terminate the identification of the named user ID as the CURRENT publisher.
REVOKE PUBLISH FROM userid
Must have DBA authority.
Automatic commit.
REVOKE PUBLISH statement [SQL Remote]