Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
Administrator's GuideThe HCL OneDB™ Administrator's Guide provides the information required to administer HCL OneDB™.
The database server
Client/server communicationThese topics explain the concepts and terms that you must understand in order to configure client/server communication.
Connectivity filesThe connectivity files contain the information that enables client/server communication and enable a database server to communicate with another database server.
Network security filesHCL® OneDB® products follow standard security procedures that are governed by information contained in the network security files.
The netrc informationThe netrc information is optional information that specifies identity data. A user who does not have authorization to access the database server or is not on a computer that is trusted by the database server can use this file to supply a name and password that are trusted. A user who has a different user account and password on a remote computer can also provide this information.
User impersonationThe database server must impersonate the client to run a process or program on behalf of the client for certain client queries or operations.

User impersonation

The database server must impersonate the client to run a process or program on behalf of the client for certain client queries or operations.

In order to impersonate the client, the database server must receive a password for each client connection. Clients can provide a user ID and password through the CONNECT statement or netrc information.

The following examples show how you can provide a password to impersonate a client.

netrc

machine trngpc3 login bruce password im4golf

CONNECT statement

CONNECT TO ol_trngpc3 USER bruce USING "im4golf"