CheckPermissions Property
The CheckPermissions property specifies how the permissions are checked at Publisher before a Subscriber INSERT, UPDATE, or DELETE operation can be uploaded.
Applies To
MergeArticle2 Object |
Syntax
object.CheckPermissions [= value]
Parts
object
Expression that evaluates to an object in the Applies To list
value
Long integer that specifies permissions checking behaviors as described in Settings
Data Type
Long, enumerated
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetCheckPermissions(SQLDMO_CHECKPERMISSIONS_TYPE FAR* pRetVal);
HRESULT SetCheckPermissions(SQLDMO_CHECKPERMISSIONS_TYPE NewValue);
Settings
Set value using these SQLDMO_CHECKPERMISSIONS_TYPE values. SQLDMO_CHECKPERMISSIONS_TYPE is a bitmask; therefore multiple options can be specified at the same time.
Constant | Value | Description |
---|---|---|
SQLDMOCheckPermissions_DeleteCheck | 4 | Check permissions at the Publisher before a Subscriber-side DELETE can be uploaded. |
SQLDMOCheckPermissions_InsertCheck | 1 | Check permissions at the Publisher before a Subscriber-side INSERT can be uploaded. |
SQLDMOCheckPermissions_NoCheck | 0 | Do not check permissions. |
SQLDMOCheckPermissions_UpdateCheck | 2 | Check permissions at the Publisher before a Subscriber-side UPDATE can be uploaded. |
Remarks
An application can set the CheckPermissions property using a combination of the values described in Settings.
Note If an application sets CheckPermissions after the initial snapshot has been created, a new snapshot must be generated and reapplied to each subscription. Snapshots are applied when the next scheduled snapshot and merge agent run
If an application calls CheckPermissions on an instance of Microsoft® SQL Server™ version 7.0, the constant, SQLDMO_E_SQL80ONLY, and the message "This property or method requires Microsoft SQL Server 2000" are returned.