Home
SecurityYou can secure your HCL OneDB™ database server and the data that is stored in your HCL OneDB™ databases. You can encrypt data, secure connections, control user privileges and access, and audit data security.
Security in HCL OneDB™The HCL OneDB™ Security Guide documents methods for keeping your data secure by preventing unauthorized viewing and altering of data or database objects, including how to use the secure-auditing facility of the database server.
Securing data
Discretionary access controlDiscretionary access control verifies whether the user who is attempting to perform an operation has been granted the required privileges to perform that operation.
Enabling non-DBSA users to view SQL statements in an active sessionYou can enable non-database server administrator (DBSA) users to view SQL statements in an active session.

Enabling non-DBSA users to view SQL statements in an active session

You can enable non-database server administrator (DBSA) users to view SQL statements in an active session.

By default, the onstat commands that show the SQL statement text from an active session are restricted to DBSA users. To remove this restriction, set the UNSECURE_ONSTAT configuration parameter to 1. The onstat commands that show SQL statements include onstat -g his, onstat -g ses, onstat -g stm, onstat -g ssc, and onstat -g sql.

The UNSECURE_ONSTAT configuration parameter takes effect when the database server is shut down and restarted.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.