Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
CONNECT statementUse the CONNECT statement to connect to a database environment. This statement is an extension to the ANSI/ISO standard for SQL.
USER Authentication Clause
Use of the Default User IDIf you do not supply the USER Authentication clause, the default user ID is used to attempt the connection.

Use of the Default User ID

If you do not supply the USER Authentication clause, the default user ID is used to attempt the connection.

The default user ID is the login name of the user running the application. In this case, you obtain network permissions with the standard authorization procedures. For example, on UNIX™, the default user ID must match a user ID in the trusted-host file (the /etc/hosts.equiv file or the file specified by the REMOTE_SERVER_CFG configuration parameter). On Windows™, you must be a member of the domain, or if the database server is installed locally, you must be a valid user on the computer where it is installed.