creating database users - how to do that ?

Hans-Georg Thien <thien@concept-software.de> writes: > As a long term oracle user I was used to create a new database user > simply with e.g. > > create user rmail identified by rmail; > grant connect to rmail;> etc., etc. > > It seems that informix does not know a "create user" statement. What > else must I use ? Informix depends on authenticated users from the OS it's running on. Add your users on your OS and GRANT them what you'd like. > I read the informix manuals very carefully but could not find any hints. Read'em again sam;) Thomas

As a long term oracle user I was used to create a new database user simply with e.g. create user rmail identified by rmail; grant connect to rmail; etc., etc. It seems that informix does not know a "create user" statement. What else must I use ? I read the informix manuals very carefully but could not find any hints. thanks for help, - hans

Informix uses the OS to validate users. As long as the user id exists for the OS, all you have to do is grant permissions to it, unless you have granted permissions to public. e.g. grant connect to rmail. In article <3940E260.433F9318@concept-software.de>, Hans-Georg Thien <thien@concept-software.de> wrote: > As a long term oracle user I was used to create a new database user > simply with e.g. > > create user rmail identified by rmail; > grant connect to rmail;> etc., etc. > > It seems that informix does not know a "create user" statement. What > else must I use ? > > I read the informix manuals very carefully but could not find any hints. > > thanks for help, - hans > > -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.