Re: Informix "SUPER USER"

Christof Koeberlein wrote: > > >I've tried the user that created the database and I tried the "Informix" > >user but none of them worked. > > Just try "informix". The Database-Account IS Case-Sensitive... > > Hope it works Well, not exactly. Informix's security relies on the underlying OS security. (There are good and bad points to this.) Sybase creates its own user security which is independant of the userid used to log in to the system. (Good and bad points here too.) Sybase has an administrator account SA as the administrator account, so that when you log in to Sybase, you can log in to SA from any account. Informix doesn't have this problem/feature. You first have to log in to the UNIX system as userid: informix, or do an su - informix. (To get the variables and stuff.) Then you need to grant dba to the specific Unix users..... (Use DBACCESS if its still around....) -Mikey -- #include <std_disclaimer.h> /* Mike Segel (MS385) */ #include <No_Spam.h> #ifdef OFFENDED_BY_CONTENT The author takes no responsibility for this post. Any resembalence to a coherent rational thought is purely coincidence. -The Management. #endif ***************************** * Attention * -*- Due to AGIS's Refusal to Act Responsibly -*- Due to ACSI's Refusal to Act Responsibly We are blocking all of their domains at the packet level. This block will exist until they modify their policies to conform to existing RFCs and net community standards. We encourage all ISPs and domain holders to do the same. *****************************