[ From: "Philip Nelson (DBA)" <[EMAIL PROTECTED]> ] I'm needing help with getting users able to access a DB2 for NT V5.2 server we're setting up (yes I know it is ancient / out-of-support but we have a good reason).
Basically I can log in from a client using the install (db2admin) user ID. However a user, set up by our Security Admin team, gets a "Invalid User ID or password" when trying to connect. As a Unix DBA I don't really understand NT authentication, although I have read Appendix R in the Admin Guide. Here's the scenario - === DBA Report ====== The server SERVER1 has had DB2 installed, with local admin user db2admin. >From a DB2 side, I've connected to the database and issued the SQL command : GRANT SELECT, INSERT, UPDATE, DELETE ON table TO GROUP GROUP1; for each table in the database. === End of DBA Report ====== === Security Admin Report ===== SERVER1 has been added to NT resource domain DOMAINDEV. A local group GROUP1 has been added to SERVER1. User account USER1 have been created under our NT accounts domain DOMAINACC. DOMAINACC is trusted by DOMAINDEV, therefore the user's DOMAINACC NT account have been added to the local groups on SERVER1. This means that by signing on with his DOMAINACC account, the user has the ability to access anything which the local groups on DOMAINDEV and SERVER1 have been associated with. === End of Security Admin Report ===== What are we missing ? TIA Phil Nelson - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** You are subscribed to [EMAIL PROTECTED] *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
