The CheckPermissions property specifies how the permissions are checked at Publisher before a Subscriber INSERT, UPDATE, or DELETE operation can be uploaded.
object.CheckPermissions [= value]
object
Expression that evaluates to an object in the Applies To list
value
Long integer that specifies permissions checking behaviors as described in Settings
Long, enumerated
Read/write
HRESULT GetCheckPermissions(SQLDMO_CHECKPERMISSIONS_TYPE FAR* pRetVal);
HRESULT SetCheckPermissions(SQLDMO_CHECKPERMISSIONS_TYPE NewValue);
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. |
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.