Contents Index REVOKE CONSOLIDATE statement [SQL Remote] REVOKE REMOTE statement [SQL Remote]

ASA SQL Reference
  SQL Statements

REVOKE PUBLISH statement [SQL Remote]


Description 

Use this statement to terminate the identification of the named user ID as the CURRENT publisher.

Syntax 

REVOKE PUBLISH FROM userid

Usage 

Each database in a SQL Remote installation is identified in outgoing messages by a publisher user ID. The current publisher user ID can be found using the CURRENT PUBLISHER special constant. The following query identifies the current publisher:

SELECT CURRENT PUBLISHER

The REVOKE PUBLISH statement ends the identification of the named user ID as the publisher.

You should not REVOKE PUBLISH from a database while the database has active SQL Remote publications or subscriptions.

Issuing a REVOKE PUBLISH statement at a database has several consequences for a SQL Remote installation:

If you change the publisher user ID at any consolidated or remote database in a SQL Remote installation, you must ensure that the new publisher user ID is granted REMOTE permissions on all databases receiving messages from the database. This will generally require all subscriptions to be dropped and recreated.

Permissions 

Must have DBA authority.

Side effects 

Automatic commit.

See also 

GRANT PUBLISH statement [SQL Remote]

REVOKE REMOTE statement [SQL Remote]

REVOKE REMOTE DBA statement [SQL Remote]

REVOKE CONSOLIDATE statement [SQL Remote]

sp_publisher procedure

Standards and compatibility 
Example 
REVOKE PUBLISH FROM publisher_ID

Contents Index REVOKE CONSOLIDATE statement [SQL Remote] REVOKE REMOTE statement [SQL Remote]