Re: stored procedure

In article <34C909AB.88A35CAF@courion.com>, Lisa Lombardo <llombardo@courion.com> writes >Hi. > >I am very new to Informix database usage. > >Is there a stored procedure similar to Sybase's sp_password that can be >called to reset a database user's password? > >Lisa >============================================ > Courion Corporation >Lisa Lombardo 16 Tech Circle >llombardo@courion.com Natick, MA 01760 >508-650-0330x203 www.courion.com >Fax:508-650-0001 "Surf to Solve..." >============================================ > > Informix does not have passwords in the database. Are you connecting from a PC. If so either a) the application has it's own password, probably stored in an .ini file or in the Registery. b) The password is your UNIX password. In which case users will need to get a telnet session to the UNIX machine, login and run passwd to change their password. If the user has forgotten their password try logging into UNIX as root and doing passwed <username> -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care