CheckPermissions Property
Diese Funktion wird in zukünftigen Versionen von Microsoft SQL Server nicht mehr bereitgestellt. Verwenden Sie diese Funktion beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.
The CheckPermissions property specifies how permissions are checked at the Publisher before a Subscriber INSERT, UPDATE, or DELETE operation can be uploaded.
Syntax
object
.CheckPermissions [= value]
Parts
object
An expression that evaluates to an object in the Applies To list.value
A 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 valueusing 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 |
Checks permissions at the Publisher before a Subscriber-side DELETE can be uploaded. |
SQLDMOCheckPermissions_/InsertCheck |
1 |
Checks permissions at the Publisher before a Subscriber-side INSERT can be uploaded. |
SQLDMOCheckPermissions_/NoCheck |
0 |
Does not check permissions. |
SQLDMOCheckPermissions_/UpdateCheck |
2 |
Checks permissions at the Publisher before a Subscriber-side UPDATE can be uploaded. |
Hinweise
An application can set the CheckPermissions property using a combination of the values described in Settings.
.gif "Hinweis") Hinweis |
|---|
If an application sets CheckPermissions after the initial snapshot has been created, a new snapshot must be generated and then 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 or later" are returned.