CheckPermissions Property

SQL-DMO

SQL-DMO

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.