Export (0) Print
Expand All
Expand Minimize
1 out of 1 rated this helpful - Rate this topic

Safety Options Property

SQL Server 2000

Safety Options Property

  New Information - SQL Server 2000 SP3.

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 value of the Safety Options property determines whether or not the PASSTHROUGH keyword is allowed in local cubes. If a client application attempts to create a local cube with an INSERT INTO statement that contains the PASSTHROUGH keyword, or if a client application attempts to refresh a local cube that contains an INSERT INTO statement which uses the PASSTHROUGH keyword, an error is raised.

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_ALL.

DBPROPVAL_MSMD_SAFETY_OPTIONS_ALLOW_ALL This value enables all user-defined function libraries without verifying that they are safe for initialization and scripting and allows usage of the PASSTHROUGH keyword in local cubes.

Security Note  This option is not recommended.

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 and prevents usage of the PASSTHROUGH keyword in local cubes.
DBPROPVAL_MSMD_SAFETY_OPTIONS_ALLOW_NONE This value prevents user-defined functions from being used during the session and prevents usage of the PASSTHROUGH keyword in local cubes.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.