RE: DB2 User Management

My bet would be PUBLIC is granted connect rights...

Douglas Kostelnik
Senior Database Administrator/Architect
[Email address protected]
AAA Auto Club South
(813)-289-1342

-----Original Message-----
From: Serge Rielau
[mailto:db2udbdba-ezmlmshield-x83058446.[Email address protected]
Sent: Monday, October 24, 2005 1:35 AM
To: LazyDBA Discussion
Subject: Re: DB2 User Management

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
>

---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

<html>
 <align=justify> 
_____________________________________________________________ 
The information transmitted is intended only for the person(s) or entity to which it is addressed and may contain confidential and or privileged material and should be treated as a confidential AAA Auto Club South communication. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.
</html>

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