on 01-23-2015 4:52 PM
We are trying Set up DB2 user passwords to never expire and we need a Technical Justification Document.
Hi Krishna ,
Can you detail on your requirement .
Is it that, you want to know why the users should be set to never exiprable
Thanks ,
Manu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Krishna ,
If your DB2 system is the backend DB of an SAP system then the users that are generally set to non expirable are sap<sid> , sap<sid>db ( if java ), sapadm etc .
Normally an SAP system is installed with the confidence that it is highly available , ie it is available for end user to access 24/7
The SAP connects to the DB using the sap<sid> user and incase this user gets expired all the db operations will be hanging back eventually failing . (The user password will expire any time )This does not help in assuring that the system is HA/ near HA . [A time critical job might fail , an important update might fail]
Hence we set the passsword to never expirable .
If their is a password policy for the client such that every password should be changed then the above comes in conflict . You have the option to define a process to cater this . Normally the password is changed every quarter/year depending on the security policy
Thanks ,
Manu
.
Hi Krishna
I think that is not possible.
You can check in DB administration Guide SAP on IBM DB2 for LUW chapter 4 : User Management. I couldn't find any exact document saying unlimited password. May be in roles you can try to set it expiry as unlimited option.
Regards
Venkat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.