mspublication-access-transact-sql.md

title	MSpublication_access (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	replication
ms.tgt_pltfrm
ms.topic	language-reference
applies_to	SQL Server
f1_keywords	MSpublication_access_TSQL MSpublication_access
dev_langs	TSQL
helpviewer_keywords	MSpublication_access system table
ms.assetid	7bebe47e-3153-4579-8092-5723667a24c6
caps.latest.revision	24
author	BYHAM
ms.author	rickbyh
manager	jhubbard

MSpublication_access (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

The MSpublication_access table contains a row for each [!INCLUDEmsCoName] [!INCLUDEssNoVersion] 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	[!INCLUDEmsCoName] Windows accounts that exist at both Publisher and Distributor side.

See Also

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)