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)

Connect to the database as a user with DBA authority.
In the left pane, select the Users & Groups folder.
Right-click the user who has PUBLISH permission and choose Revoke Publisher.

To revoke PUBLISH permission (SQL)

Connect to the database as a user with DBA authority.
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;

Revoke PUBLISH permission

Caution

To revoke PUBLISH permission (Sybase Central)

To revoke PUBLISH permission (SQL)

See also