n is either 1 or 0. The default value is 1.
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.
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).