No Privileges for User groups

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ingo-christian.kollesch@atosorigin.com - 02 Dec 2005 10:10 GMT

Hi,
When I connect with my database, I became the error "Username and/or
password invalid".

I have created a usergroup AG41 with User AG1 and AG2 on my Win2000
PDCN.
Next step, I have create a group UG41 on my Database-Server. I have add
the Usergroup AG41 from the domain in UG41.
I have create a usergroup UG41 in my database, with privileges connect
with database and select for one table.

What ist wrong?
What is missing?
I have bad Server allocations?

Reply to this Message

Mark Yudkin - 02 Dec 2005 13:20 GMT

1) Don't nest: UG41 - AG41 - AG1. You have to place AG41 straight into UG41.
Feel free to curse and swear. You can also open a requirement with IBM to
have this annoying and gratuitous limitation lifted.
2) db2set -g DB2_GRP_LOOKUP=LOCAL
You may need to do this for each instance too.

BTW, is there any reason why you cannot set authentication to Kerberos and
thereby get strong security without making the user re-enter his password
and thereby curse and swear about you?

> Hi,
> When I connect with my database, I became the error "Username and/or
[quoted text clipped - 10 lines]
> What is missing?
> I have bad Server allocations?

Reply to this Message

ingo-christian.kollesch@atosorigin.com - 06 Dec 2005 14:34 GMT

Thank you for the Tip with Kerberos.
Where can I kerberos buy/order and where became I more information for
this tool.
But my problem with the access to the DB2-Server is not repair.
Have you a address from a admin or developer, which speak german, my
english ist very bad.
What ist the way, about the user from the PDCN-domain (Win2K) to logon?
In DB2 User group I see the created groups an I have the privileges
assign.

Ingo

Reply to this Message