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).