MSpublication_access (Transact-SQL)

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

The ID of the publication.

login

sysname

Microsoft Windows accounts that exist at both Publisher and Distributor side.