IDS - How to find users in a database
A poster asked how to list all users of an Informix database. Replies first covered currently connected users: onstat -g ses, onstat -u, onstat -g sql <session>, plus sysmaster tables such as syssessions, sysuserthreads, sysnetworkio and syssesprof. The poster clarified he wanted users permitted to connect, whether or not they are logged in. Art Kagel noted you can list users holding explicit database privileges, but not everyone who could connect via implicit PUBLIC grants. No concrete query or final answer is recorded; the thread ends with a joke post.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello, Is a way to find out the all the users in a database? Thank You! Reyna _________________________________________________________ Reyna Sabina Phone: (305) 361-4324 NOAA/AOML/PHOD Fax: (305) 361-4392 4301 Rickenbacker Causeway Email: Reyna.Sabina@noaa.gov Miami, FL 33149-1087 "Things do not get better by being left alone." -Winston Churchill
All of the users currently connected, all of the users who are explicitely privileged in the database, or all users who can possibly connect to the database even with implicit privileges (ie through the pseudo-user PUBLIC)? Ans: Yes. Yes. No. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Oct 2, 2009 at 1:02 PM, Reyna.Sabina <Reyna.Sabina@noaa.gov> wrote: > Hello, > > Is a way to find out the all the users in a database? > > Thank You! > > Reyna > _________________________________________________________ > Reyna Sabina Phone: (305) 361-4324 > NOAA/AOML/PHOD Fax: (305) 361-4392 > 4301 Rickenbacker Causeway Email: Reyna.Sabina@noaa.gov > Miami, FL 33149-1087 > > "Things do not get better by being left alone." > > -Winston Churchill > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0015174c35203d03580474f74541
Reyna,
Hi,
You can find out the current users using the onstat comand.
$ onstat -g ses 'Show you the users are currently connected
or
$ onstat -u
In both of them, the session column number, can be used to see what the user
are doing.
$ onstat -g sql session_number
Regards.
João Ricardo Oliveira
Rio 2016 - Brazil (The Olympic Games It´s ours now!)
----- Original Message -----
From: "Reyna.Sabina" <Reyna.Sabina@noaa.gov>
To: <ids@iiug.org>
Sent: Friday, October 02, 2009 1:02 PM
Subject: IDS - How to find users in a database [17297]
> Hello,
>
> Is a way to find out the all the users in a database?
>
> Thank You!
>
> Reyna
> _________________________________________________________
> Reyna Sabina Phone: (305) 361-4324
> NOAA/AOML/PHOD Fax: (305) 361-4392
> 4301 Rickenbacker Causeway Email: Reyna.Sabina@noaa.gov
> Miami, FL 33149-1087
>
> "Things do not get better by being left alone."
>
> -Winston Churchill
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
Hi,
onstat -g ses is a good starting point. onstat -u and onstat -g sql mayalso be useful. In addition, there are several tables (syssessions,
sysuserthreads, sysnetworkio, syssesprof...) in the sysmaster database
that contain that info an more. What are you looking for?
Cheers,
Dick
Dick Snoke
Executive IT Specialist
IBM Software Group
Tel: (404) 487-1595
Email: dsnoke@us.ibm.com
From:
"Reyna.Sabina" <Reyna.Sabina@noaa.gov>
To:
ids@iiug.org
Date:
10/02/09 01:03 PM
Subject:
IDS - How to find users in a database [17297]
Sent by:
ids-bounces@iiug.org
Hello,
Is a way to find out the all the users in a database?
Thank You!
Reyna
_________________________________________________________
Reyna Sabina Phone: (305) 361-4324
NOAA/AOML/PHOD Fax: (305) 361-4392
4301 Rickenbacker Causeway Email: Reyna.Sabina@noaa.gov
Miami, FL 33149-1087
"Things do not get better by being left alone."
-Winston Churchill
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
On Fri, 2 Oct 2009, Joao Ricardo Dias de Oliveira wrote:
> Reyna,
>
> Hi,
>
> You can find out the current users using the onstat comand.
>
> $ onstat -g ses 'Show you the users are currently connected>
> or
>
> $ onstat -u>
> In both of them, the session column number, can be used to see what the u=
ser
> are doing.
>
> $ onstat -g sql session_number>
Joao, I'm not referring to the user that are connected to a session.
But what I am after is the users that are allowed to connect to
a database even if the user(s) is/are not connected.
Obrigado, parabens for the Olympics.
> Regards.
>
> Jo=E3o Ricardo Oliveira
> Rio 2016 - Brazil (The Olympic Games It=B4s ours now!)
>
> ----- Original Message -----
> From: "Reyna.Sabina" <Reyna.Sabina@noaa.gov>
> To: <ids@iiug.org>
> Sent: Friday, October 02, 2009 1:02 PM
> Subject: IDS - How to find users in a database [17297]
>
> > Hello,
> >
> > Is a way to find out the all the users in a database?
> >
> > Thank You!
> >
> > Reyna
> > _________________________________________________________
> > Reyna Sabina Phone: (305) 361-4324
> > NOAA/AOML/PHOD Fax: (305) 361-4392
> > 4301 Rickenbacker Causeway Email: Reyna.Sabina@noaa.gov
> > Miami, FL 33149-1087
> >
> > "Things do not get better by being left alone."
> >
> > -Winston Churchill
> >
> >
> >
> *************************************************************************=
******
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
>
> *************************************************************************=
******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
This is all just too complicated for me. My way of determining how many users are in my system is by killing the power on my IDS database server, then I watch the help desk line to see who calls in saying that they can't connect to the database. They really hate it when I do this 2 or 3 times a day. (You know I'm purely kidding here, but wishful thinking does put a smile on my face) [Yes! Obnoxio has had a profound influence on me] :o) Happy Friday! Jonathan B. Smaby Pomona College phone: (909) 621-8506 email: jonathan.smaby@pomona.edu web: http://www.facebook.com/jonathan.smaby ------------------------------------------------------------- This message has been scanned by Postini anti-virus software.