Safety Options Property

Analysis Services Programming

Analysis Services Programming

Safety Options Property

This property determines how security for user-defined functions and actions is handled.

Property Name

Safety Options

Property ID

DBPROP_MSMD_SAFETY_OPTIONS

Remarks

The value of the property determines whether unsafe libraries can be registered and loaded by PivotTableĀ® Service or the server. If an attempt is made to load an unsafe library or reference an unsafe user-defined function while safety checking is enabled, then PivotTable Service will return the following error:

User defined function <function name> cannot be used, because the class that implements it is not safe for initialization or scripting, which is required by client settings.

The following table lists the possible values for this property.

Value Description
DBPROPVAL_MSMD_SAFETY_OPTIONS_DEFAULT For connections to a local cube, or via an IIS server, this value is the same as DBPROPVAL_MSMD_SAFETY_OPTIONS_ALLOW_SAFE.

For all other connections, this value is the same as DBPROPVAL_MSMD_SAFETY_OPTIONS_ALLOW_SAFE.

DBPROPVAL_MSMD_SAFETY_OPTIONS_ALLOW_ALL This value enables all user-defined function libraries without verifying that they are safe for initialization and scripting.
DBPROPVAL_MSMD_SAFETY_OPTIONS_ALLOW_SAFE This value ensures that all classes for a particular user-defined function library are checked to ensure that they are safe for initialization and scripting.
DBPROPVAL_MSMD_SAFETY_OPTIONS_ALLOW_NONE This value prevents user-defined functions from being used during the session.