USER, PASS - set SQL user and password

SYNOPSIS

<USER = user>
<PASS = pass>


DESCRIPTION
The USER and PASS commands set the SQL user and password for accessing databases. These values will be used by future <SQL> statements, unless overridden by the USER and PASS options to a particular <SQL> (here).


EXAMPLE

<USER = bob>
<PASS = robert>
<SQL "select Salary from employee">
  $Salary
</SQL>


CAVEATS
The USER and PASS commands should occur before any SQL statements.

For security, the arguments to USER and PASS should not be plain-text strings in a user-visible script.


SEE ALSO
SQL


Copyright © Thunderstone Software     Last updated: Oct 24 2023
Copyright © 2024 Thunderstone Software LLC. All rights reserved.