Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Database Login
- Thread starter ADB1
- Start date
It is not possible to have the system prompt for database id and pwd.
You can either use a generic one entered in the connection or you can pass the BO user ID and password to the database. The problem with the second option is that you have no way to ensure the passwords are syncrhonized.
Steve Krandel
VERITAS Software
You can either use a generic one entered in the connection or you can pass the BO user ID and password to the database. The problem with the second option is that you have no way to ensure the passwords are syncrhonized.
Steve Krandel
VERITAS Software
BrianTyler
IS-IT--Management
Steve,
We started by using generic login and password for the database (DB2), but we soon ran into trouble when the DBA found out! He was having a lot of difficulty identifying which users were running queries that were taking too many resources.
We then changed to using the BO login as the authority for the database. Each user was given an icon on the desktop (which runs a background script) and were instructed to use it to change their passwords whenever the BO password was changed (every two weeks). This approach has been more successful but we do have problems when some of our 'more limited' users forget to change the database passwords and report BO faults.
Brian
We started by using generic login and password for the database (DB2), but we soon ran into trouble when the DBA found out! He was having a lot of difficulty identifying which users were running queries that were taking too many resources.
We then changed to using the BO login as the authority for the database. Each user was given an icon on the desktop (which runs a background script) and were instructed to use it to change their passwords whenever the BO password was changed (every two weeks). This approach has been more successful but we do have problems when some of our 'more limited' users forget to change the database passwords and report BO faults.
Brian
- Thread starter
- #5
Brian,
You need to re-educate your DBA. Even if you use a generic password, it is still quite well possible to track the individual user based on his network ID. This is both possible with proper db2 command line statements / freeware DBA tools.
I'm not at work now ,but I can suggest a cool monitor which will do just the proper job your DBA needs. (DB2 being VERY poorly in monitoring functionality as it is)
Ties Blom
Information analyst
You need to re-educate your DBA. Even if you use a generic password, it is still quite well possible to track the individual user based on his network ID. This is both possible with proper db2 command line statements / freeware DBA tools.
I'm not at work now ,but I can suggest a cool monitor which will do just the proper job your DBA needs. (DB2 being VERY poorly in monitoring functionality as it is)
Ties Blom
Information analyst
BrianTyler
IS-IT--Management
Ties,
Thanks for your response. I'll have words with the DBA.
If anyone knows of any FREE monitors which run on AIX, I expect a number of us would like to know about them. It could be a useful seperate thread in this forum.
Regards,
Brian
Thanks for your response. I'll have words with the DBA.
If anyone knows of any FREE monitors which run on AIX, I expect a number of us would like to know about them. It could be a useful seperate thread in this forum.
Regards,
Brian
- Status
Similar threads
- Locked
- Question