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 |