1) Informix use the OS user as default to authentication
2) if executed the dbaccess from a remote machine, they use your logged user to connect, if they don't exists, you got this error 951)
Quote:
>finderr 951
-951 User username is not known on the database server.
The database server that you tried to access does not accept either
your user ID, the login name that is specified for the desired server
host in your ~/.netrc file, or the user name that is specified in the
USER clause of a CONNECT statement. If you are explicitly specifying
your user name in the ~/.netrc file or in a CONNECT statement, check
that the name is correct. If you do not have a valid user ID on the
server computer, see your system administrator. This message appears
with Version 6.0 and later.
|
3) dbaccess have some limitations with conection authentication...
4) Have a several ways to solve this..
a) configure a .netrc (client side)
b) configure a hosts.equiv (server side)
c) use the commando "connect" in your script and don't specify the database on the command: dbaccess - yourscript.sql
check the manual for more information:
CONNECT