mspublication-access-transact-sql.md

title	MSpublication_access (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	replication
ms.topic	language-reference
f1_keywords	MSpublication_access_TSQL MSpublication_access
dev_langs	TSQL
helpviewer_keywords	MSpublication_access system table
ms.assetid	7bebe47e-3153-4579-8092-5723667a24c6
author	stevestein
ms.author	sstein

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)