Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Remote » Creating SQL Remote systems » User permissions » PUBLISH permission

 

Revoke PUBLISH permission

Use the following procedure to revoke the PUBLISH permission from a user.

Caution

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.

 To revoke PUBLISH permission (Sybase Central)
  1. Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority.

  2. In the left pane, select the Users & Groups folder.

  3. Right-click the user who has PUBLISH permission and choose Revoke Publisher.

 To revoke PUBLISH permission (SQL)
  1. Connect to the database as a user with DBA authority.

  2. Execute a REVOKE PUBLISH statement to revoke the PUBLISH permission from the current publisher. See REVOKE PUBLISH statement [SQL Remote].

    For example:

    REVOKE PUBLISH FROM cons;
 See also