Could it be you have CONNECT granted to PUBLIC or some other OS GROUP the
user is a member of?

Cheers
Serge


"Ashish Kumar Aggarwal "
<db2udbdba-ezmlmshield-x62560797.[Email address protected] wrote on
10/24/2005 12:54:31 AM:

> LeavesHi all
>
> Please Guide me on where to find information about User Management in
DB2.
>
> I need to create two users : 1 as Administrator and the other as
> User who in the begening have create rights but as the database is
> deployed he should have only access rights.
>
> I tried using REVOKE CONNECT on a temp user created by me but
> despite of successful execution of the command I could still connect
> to database using the same user. How come.
>
> I'm running DB2 UDB Express Edition 8.1 with Fix Pack 10 on Windows
> 2000 Server System
>
> Kindly Guide
>
> Ashish
>
>
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>


DB2 & UDB email list listserv db2-l LazyDBA home page