user list

Santhosh

Dear All

Can you guys please help me in displaying the list of users in a DB2
instance? I need the user ID, privileges etc .. I use Db2 8.1.X under
windows environment..

Is it possible to know the last login date for a user?

Regards
Santhosh

Jun 26 '06 #1

Subscribe Post Reply

4506

Mark A

"Santhosh" <ko******@yahoo.com> wrote in message
news:11**********************@y41g2000cwy.googlegr oups.com...

Dear All

Can you guys please help me in displaying the list of users in a DB2
instance? I need the user ID, privileges etc .. I use Db2 8.1.X under
windows environment..

Is it possible to know the last login date for a user?

Regards
Santhosh

Users in DB2 are controlled by the operating system. If you want to know
what operating system users or groups have been granted specific access to
DB2 resources, then check the DB2 catalog views (dbauth, tabauth, etc).
These views are documented in Appendix D of the SQL Reference vol 1.

DB2 cannot determine when someone logged on with a password to the operating
system, but it can track connections to DB2 via the db2audit facility.

Jun 26 '06 #2

by: Marc Walgren | last post by:

Greetings I have an ASP application to enter reservations. There are multiple user security settings that require some users to have a restricted list of client in a drop list on a form. I...

ASP / Active Server Pages

Keeping track of what a user has read on a web site

by: Sandman | last post by:

Just looking for suggestion on how to do this in my Web application. The goal is to keep track of what a user has and hasn't read and present him or her with new material I am currently doing...

PHP

Client/Server socket send user input

by: jas | last post by:

I have a basic client/server socket situation setup....where the server accepts a connection and then waits for commands. On the client side, I create a socket, connect to the server...then I...

Python

Mutli-user Update using Recordset.AddNew and mutliselection ListBoxes - 3 questions

by: Ryan | last post by:

Hello, I have a quick question (I hope). I have a form with a combo box and a multi-selection list box. The list box is based on a query. Users can select values from the cmbobox to add to...

Microsoft Access / VBA

User Control Access from Javascript

by: trinitypete | last post by:

Hi all, I have a user control that uses control literal to build a heading with a link, and a div containing links below. As the link heading is hit, I want to change the style of the div,...

ASP.NET

Design Issue: Separating Application Security Model from the Application (Custom or User) Controls

by: Earl Teigrob | last post by:

Background: When I create a ASP.NET control (User or custom), it often requires security to be set for certain functionality with the control. For example, a news release user control that is...

ASP.NET

Get list of the Groups a User belongs to

by: Jeff Williams | last post by:

How can I get a list of the Groups both Local and Domain groups a User belongs to.

C# / C Sharp

design guidance please :user controls and centralizing roles-related display stuff

by: | last post by:

I'm looking for some design guidance on a collection of projects I'm working on. The project involves a bunch of websites constructed out of a collection of user controls. Different user...

ASP.NET

How to Generate a User List

by: ADezii | last post by:

For this Tip, we will show you an extremely handy, multi-user, feature of Jet that allows you to manage Users more effectively. You can create a special, provider-specific Recordset in ADO that...

Microsoft Access / VBA

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

Similar topics