How do you create Informix users in SCO Unix/Windows 2000?

[antzzz]

Maybe it's me, but I'm not able to locate good decent information about creating database users in IDS 7.31 in SCO Unix 5.0.5/Windows 2000. I know how to grant them permissions using SQL but how do I make database users in the first place??? Where do I start (a more specific question is how do I map the SCO users or Windows NT logins to become Informix database users)?

Can anyone show me a quick step-by-step procedure?

Thanks!

 

[vpshriyan]

Hi,

Users are not created at database level in informix, However, users of Operating System (OS) are granted with privileges for database usage using the SQL statements (grant/revoke).

The authorised users information is recorded in the "sysusers" table in the database where the privileges are given to the users. Informix does NOT maintain password for these users separately.

If "ravi" an OS user wants to get into "testdb" database and select from a table tab1, follow the steps:

1. echo "grant connect to 'ravi'" | dbaccess testdb
2. echo "grant select on tab1 to 'ravi'" | dbaccess testdb

To see the effect at the backend:

select * from sysusers where username='ravi';
info access for tab1;

Regards,
Shriyan

"An ounce of example is worth a pound of advice."