RE: Creating users

Any informix user has to be a UNIX user. So create a unix user first if you want to create an informix user. Set the environment variable INFORMIXDIR(Complete path of the informix directory) for that user. Grant connect permission to that user (To be done by the owner of thedatabase or "informix" user). The answer to the second question is REVOKE ALTER/INSERT/INDEX/DELETE/UPDATE [Column names] ON tab_name FROM [public/user_names] Cheers, Jamini Kant ------------------------------------------------------------ Hi Informix'ers I am new to informix. How do you create users in informix. When I use tbmonitor to view informix users, i can see unix logins. How do i restrict permissions on tables ?. Can anybody tell me ? Amita The clock is running, make the most of today.......