Use the following procedure to revoke the PUBLISH permission from a user.
Changing the publisher at a remote database or at the consolidated database can cause serious problems for any subscriptions that the database is involved in, including the loss of information. See Changes to avoid on a running system.
Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority.
In the left pane, click the Users & Groups folder.
Right-click the user who has PUBLISH permission and click Revoke Publisher.
Connect to the database as a user with DBA authority.
Execute a REVOKE PUBLISH statement to revoke the PUBLISH permission from the current publisher.
REVOKE PUBLISH FROM cons;
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|