You don't really access the Informix database using a login and password.
The way in which Informix security works is by giving privilages to users using the GRANT command ( found in Informix documentation ).
GRANT DBA TO JOE
grants full DBA privilages whereas
GRANT INSERT ON tablename TO JOE
allows JOE to insert data to the table tablename
JOE MUST exist as a known user on the system i.e. must have a login name
and password.
If you have any other problems, give me a call.
Sean
Khanh K Mai <km...@vertex.com> wrote in article
<36543E6C...@vertex.com>...
I have gone through the Administrator's Guide of Informix Online documentation
at informix.com web site and still did not get enough information about
how to
add a new login user to Informix Database.
I mean that I would like to know those Informix DBA commands performing similar Sybase commands like :
sp_addlogin "joe" , "joe_passwd"
go
use tester_database_name
go
sp_adduser "joe"
go
Thank you very much for your help
kmai
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 296 |
Nodes: | 16 (2 / 14) |
Uptime: | 39:09:50 |
Calls: | 6,648 |
Files: | 12,193 |
Messages: | 5,329,314 |