CSPExclusions

Specifies an access service to limit access to information normally returned from sp_tables upon authorization.

Syntax

CSPExclusions=[ none | user | nonauth |nonauthpublic ]

Default

user

Values

  • none specifies no exclusions, based on authorization to information.

  • user specifies exclusions, based on specific user authorization to information.

  • nonauth specifies that a user must be granted user or group authorization to access information.

  • nonauthpublic specifies that a user must be granted user authorization, or that PUBLIC is granted some authorization.

Comment

This property is not supported and does not affect the ECDA Option for ODBC access service. It is available for compatibility purposes only.

Parent topic: Catalog Stored Procedures Properties