DBMSSecurity
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.
DBMSSecurity=1
0 or 1. The default is 1.
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).