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 tab method of the %SYSTEM.SQL.UtilOpens in a new tab 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 tab class (as described in the class reference) or by editing the CPF in a text editor (as described in Editing the Active CPF).

FeedbackOpens in a new tab