Home » SQL & PL/SQL » SQL & PL/SQL » Need to view the number of users logged in to the database (Oracle 9i,HP-UX)
Need to view the number of users logged in to the database [message #351273] Tue, 30 September 2008 03:23 Go to next message
sanei05
Messages: 103
Registered: September 2008
Senior Member
I need to view the number of users logged in to the database. How can I view it...
Re: Need to view the number of users logged in to the database [message #351274 is a reply to message #351273] Tue, 30 September 2008 03:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
v$session

Regards
Michel
Re: Need to view the number of users logged in to the database [message #351276 is a reply to message #351274] Tue, 30 September 2008 03:33 Go to previous messageGo to next message
sanei05
Messages: 103
Registered: September 2008
Senior Member
can i know how can i enable the user info in a log which can be used for future reference on what changes the users have done..
Re: Need to view the number of users logged in to the database [message #351278 is a reply to message #351276] Tue, 30 September 2008 03:40 Go to previous messageGo to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Hint:-Audit

Regards,
Rajat Ratewal
Re: Need to view the number of users logged in to the database [message #351279 is a reply to message #351276] Tue, 30 September 2008 03:41 Go to previous messageGo to next message
_jum
Messages: 509
Registered: February 2008
Senior Member
In this forum, there are some threads about
LOGON TRIGGER
They can be used to log user activities.
Re: Need to view the number of users logged in to the database [message #351298 is a reply to message #351279] Tue, 30 September 2008 04:32 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First AUDIT and then if you can't have the wanted information with audit then LOGON TRIGGER.

Regards
Michel
Previous Topic: HOW TO TRACK STORED PROCEDURE IN TRIGGER
Next Topic: :NEW in Trigger
Goto Forum:
  


Current Time: Fri Dec 09 06:02:07 CST 2016

Total time taken to generate the page: 0.10521 seconds