Create new users on informix!!
Posted in 1999
Topics: General Discussion
Does anybody know how to create a new user on informix?? I'm rookie and i don't know if informix supply any tool to do this, or if i need to log to the system as user INFORMIX (the default user that the instalation creates) and create the new users inserting rows in the table "sysusers" from the "sysmaster" database. Thanks in advance.
"Francisco Jos' Gambero Garc'a" <fgamber@clientes.unicaja.es> writes: > Does anybody know how to create a new user on informix?? I'm rookie and > i don't know if informix supply any tool to do this, or if i need to log to > the system as user INFORMIX (the default user that the instalation creates) > and create the new users inserting rows in the table "sysusers" from the > "sysmaster" database. I think (_know_) you should read "Administrator's Guide" and "Informix Guide to SQL" (The GRANT section) before doing anything... Basicly, Informix (in their great wisdom) has decided to let the OS do the user- authentication. So you have to create a OS user and GRANT that user connect to the database and approtiate access to tables. If you _really_ don't care you could do a 'GRANT DBA TO username' and cross you fingers... Thomas