Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayMSpublication_access (Transact-SQL)
Applies to: 
SQL Server
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. |
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)