Re: Ho can I create a DB-User with Informix

You do not need to explicitly create users for the informix database. If its on a unix server it recognizes all the users of the unix system as users. However you need to GRANT them permission for them to be able to access the database. This is done using the GRANT command. You can grant various levels of privilages eg:- dba, read only, etc.. Roles are a fairly recent (not new) addition to informix. Roles are used to restrict user priviladges to certain sections of the database. Roles are assigned to existing users. Chaminda Peries Cimarron Inc. DOL - Job Corps Data Center San Marcos TX. On Tue, 29 Apr 1997, Michael Jenc wrote: } Hi, } } it seems to be a very easy thing to do, but... } } I searched the whole meter documentation for somthing } like "How to create a new user" but did not find } anything. I only found how to create roles and how } to grant rights (or roles) to users. For me this } implies that there is such a thing as a user and } somehow I must be able to create new users! } } The first thing however was to execute the SQL } statement "create user Seppl identified by 'pwd'" } but informix doesn't understand how to create _user_... } } Please help me! } } BTW I have installed the Online Dynamic Server for NT } Version 7.22.TC1 } } Thanks for your help } } Ciao } Michael }