Skip to main content
Previous sectionNext section

DBMSSecurity

Enable SQL security.

Synopsis

[SQL]    DBMSSecurity=n

n is either 1 or 0. The default value is 1.

Description

When DBMSSecurity is enabled, all InterSystems SQL security is enabled. This means privilege-based table/view/procedure security is active. A user can only view or perform actions on a table for which that user has been granted privilege. When this parameter is not enabled, a user can view or perform actions on a table even if that user lacks the necessary privilege.

For further details, refer to the GRANT, CREATE TABLE, and CREATE VIEW commands.

Changing This Parameter

To set the desired value for DBMSSecurity from the Terminal, use the SetSQLSecurity() method of the %SYSTEM.SQL class. See the class reference for details. Changing this option affects only new processes; existing processes are not affected.

You can also change DBMSSecurity with the Config.SQL class (as described in the class reference) or by editing the CPF in a text editor (as described in the Editing the Active CPF section of the “Introduction to the Configuration Parameter File” chapter in this book).