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"

Copyright© 2019 HCL Technologies Limited