Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see How to Migrate to InterSystems IRIS, available on the WRC Distributions page (login required).

DBMSSecurity

Enable/disable SQL security.

Synopsis

[SQL]    DBMSSecurity=n

Description

The value n may be 1 or 0:

  • When 1 (true) Caché SQL security is enabled. This means privilege-based table/view/procedure security is active. A user can only perform actions on a table or view for which that user has been granted privilege.

  • When 0 (false) Caché SQL Security is disabled. This means privilege-based table/view/procedure security is suppressed. A user can perform actions on a table or view even if that user has no privileges to do so.

Examples

DBMSSecurity=1

Range of Values

0 or 1. The default is 1.

Management Portal

On the page System Administration > Configuration > SQL and Object Settings > General SQL Settings, for the SQL Security Enabled setting, choose Yes (true) or No (false).

Feedback