RE: User Login Problems

On 15 Jun 1995 13:36:16 -0700 John Dennis wrote: >I'm a Oracle/Sybase person moving into Informix and to tell you the >truth, logging seems a strange concept to Informix. Here's what I have ^^^^^^^ I take it you mean login >done in Oracle yet seems impossible to do in Informix: > >* Each user log-in from a PC into Informix on an HP with their own > username and password. > >* Each user can change their password (or have a privledged DB user do it.) > >It doesn't seem that a user logged into Unix can log into Informix as a >different user. It seems that Informix is lacking and is forcing me into >a design where I maintain my own list of users and have everyone log in >as the same (secret) username/password. This doesn't seem optimal. > Yes, you are right in saying that a user logged onto the Unix cannot use Informix as a different user. He will use it as himself. In fact, Informix does not require a separate login at all, which has its advantages and disadvantages. I find that good, in the following sense the sys admin can concentrate on making the operating system secure there is no separate accounts to maintain, easier for sysadmin there is no separate passwords to remember, easier for users However, because Informix requires trusted hosts on the system, this makes the job of maintaining a secure network extremely difficult. In a client server environment, the user has the option of saving his password in the I-Net for Windows, which is probably a serious security breach. >Anyway, you have been kind enough to read this much. So does anyone have >any thought or solutions to this problem? > Nope, I don't think I have a solution you want. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Calvin Ng email: <calvinng@brel.com.sg> ------------------------------------------------------------------------- [DISCLAIMER] Read at your own risks. The author is not liable for any consequences directly or indirectly involved with reading this mail. This mail MAY NOT be interpreted as those of my employer's. ------------------------------------------------------------------------- This mail is sent with the help of Chameleon TCP/IP for Windows. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=