Skip to content

Latest commit

 

History

History
35 lines (30 loc) · 1.48 KB

File metadata and controls

35 lines (30 loc) · 1.48 KB
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)