Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: TutorialThe HCL OneDB™ Guide to SQL: Tutorial shows how to use basic and advanced structured query language (SQL) to access and manipulate the data in your databases. It discusses the data manipulation language (DML) statements as well as triggers and stored procedure language (SPL) routines, which DML statements often use.
Database concepts
Concurrent use and security
Control database use

Control database use

HCL® OneDB® database software provides the means to control database use. When you design a database, you can perform any of the following functions:

Keep the database completely private
Open its entire contents to all users or to selected users
Restrict the selection of data that some users can view (different selections of data to different groups of users)
Allow specified users to view certain items, but not modify them
Allow specified users to add new data, but not modify old data
Allow specified users to modify all, or specified items of, existing data
Ensure that added or modified data conforms to the data model