Password lost - how to change it.
This is a discussion on Password lost - how to change it. within the DB2 forums, part of the Database Server Software category; --> Hi, I'm after forgetting a password for a database user. DB2 on linux client, server on zSeries. 8.1.5 is ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 09:00 AM
| ||||
| ||||
 Password lost - how to change it. Hi, I'm after forgetting a password for a database user. DB2 on linux client, server on zSeries. 8.1.5 is the version. I can connect as user SYSADM, which has full authorisations. What's the equivalent of ALTER USER SM1ADM IDENTIFIED BY PASSWORD for DB2 please? Regards.      |
|
02-27-2008, 09:01 AM
| |||
| |||
| Re: Password lost - how to change it. In article <1156511661.401382.35560@m79g2000cwm.googlegroups. com>, span3d@yahoo.com says... > uid's/pwd's in db2 for LUW is handled by the OS... > Yes, but it can be changed when entering the CONNECT statement. Check the docs at http://tinyurl.com/rb22y |
|
02-27-2008, 09:01 AM
| ||||
| ||||
| Re: Password lost - how to change it. Gert van der Kooij wrote: > In article <1156511661.401382.35560@m79g2000cwm.googlegroups. com>, > span3d@yahoo.com says... > > uid's/pwd's in db2 for LUW is handled by the OS... > > > > Yes, but it can be changed when entering the CONNECT statement. > Check the docs at http://tinyurl.com/rb22y I couldn't figure out the correct syntax to do that. The DB2 admin changed the password on the mainframe and I ran some SAP utility programs to sync the passwords again. All's OK now. |
Linear Mode
