MSpublication_access

Transact-SQL Reference

Transact-SQL Reference

MSpublication_access

The MSpublication_access table contains a row for each Microsoft® SQL Server™ login that has access to the specific publication or Publisher. This table is stored in the distribution database.

Column name Data type Description
publication_id int ID of the publication
login sysname Microsoft Windows accounts that exist at both Publisher and Distributor side