On Saturday 14 August 2004 10:59, Helen Borrie wrote:

> At 10:43 AM 14/08/2004 +0200, you wrote:
> >(Using FB 1.5.1 under Linux) - when connecting to the isql command line
> >client, is there any way of providing the password either interactively or
> >using an environment variable or file? (It seems I can either provide the
> >entire connection string as command line options and risk having the
> > password visibile to all users on the local system,
>
> Why? other users can't see a shell opened by you, can they?

ian@linux:~> /opt/firebird/bin/isql /opt/firebird/examples/employee.fdb -u SYSDBA -p SIKRET

test@linux:~> ps a | grep isql
ian 6370 3.0 0.4 3860 2076 pts/32 S+ 11:13 0:00 /opt/firebird/bin/isql /opt/firebird/examples/employee.fdb -u SYSDBA -p SIKRET
test 6378 0.0 0.1 2592 672 pts/31 S+ 11:13 0:00 grep isql

> Anyway...
>
> export ISC_USER=yourusername
> export ISC_PASSWORD=yourpassword
>
> and afterwards
> unset ISC_USER
> unset ISC_PASSWORD

Thanks. Just setting ISC_PASSWORD works as well if the username is provided explicitly.

Ian Barwick