Skip to main content

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 SetOption(“SQLSecurity”)Opens in a new window method of the %SYSTEM.SQL.UtilOpens in a new window 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.SQLOpens in a new window 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).

FeedbackOpens in a new window