Safety Options Property
New Information - SQL Server 2000 SP3.
This property determines how security for user-defined functions and actions is handled.
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.
|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.|