gebeurtenis
31 mrt, 23 - 2 apr, 23
De grootste SQL-, Fabric- en Power BI-leerevenement. 31 maart – 2 april. Gebruik code FABINSIDER om $ 400 te besparen.
Zorg dat u zich vandaag nog registreertDeze browser wordt niet meer ondersteund.
Upgrade naar Microsoft Edge om te profiteren van de nieuwste functies, beveiligingsupdates en technische ondersteuning.
Applies to:
SQL Server
Adds a login to the access list of the publication. This stored procedure is executed at the Publisher on the publication database.
Transact-SQL syntax conventions
sp_grant_publication_access
[ @publication = ] N'publication'
, [ @login = ] N'login'
[ , [ @reserved = ] N'reserved' ]
[ , [ @publisher = ] N'publisher' ]
[ ; ]
The name of the publication to access. @publication is sysname, with no default.
The login ID. @login is sysname, with no default.
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
The name of the publisher. @publisher is sysname, with a default of NULL
.
0
(success) or 1
(failure).
sp_grant_publication_access
is used in snapshot, transactional, and merge replication.
This stored procedure can be called repeatedly.
Only members of the sysadmin fixed server role or the db_owner fixed database role can execute sp_grant_publication_access
.
gebeurtenis
31 mrt, 23 - 2 apr, 23
De grootste SQL-, Fabric- en Power BI-leerevenement. 31 maart – 2 april. Gebruik code FABINSIDER om $ 400 te besparen.
Zorg dat u zich vandaag nog registreert