I am working with DB2 v8.2.2 and AIX 5.3

Hi,

after creating new user in the system it seems by default it has "connect" privilage to database (db2 connect to xxxxx was successfull), I tried to revoke the privilege I get error that:

SQL0556N An attempt to revoke a privilege from "MMTEST" was deniede because
"MMTEST" does not hold this privilege. SQLSTATE=42504.

could you please somebody tell me how come?

how can I revoke the "connect" privilege from new user?

Thank you in advance for your help.

Check the privileges of the PUBLIC "group".

Hi n_i

when I revoke the connect privilege from public yes mmtest userid does not have privilege but it effects to all userids in our environment (am I right?) that I do not like it, I want revoke just "MMTEST" userid.

By default public has connect preveleges.
If you want to revoke connect prevelege to a perticular user you have to
1. Revoke connect from public.
2. Frabt connect to only people that can be conencted.

Hope it helps

Thank you all for your help.