Determining a Session's Serial Number

   I have a need for a user to determine the serial number of his session. I can get a list of serial numbers from V$SESSION, but if there are multiple sessions with the same username I don't know how to distinguish between them. I am willing to grant the user SELECT privs on any necessary tables to accomplish this. Can anyone help me out???

• Thanks in advance
• Greg

  ---

    _/ _/_/ _/_/_/ _/_/_/ Micrographics Specialties Inc.

   _/_/ _/ _/  _/          _/     12200 Kiln Court  P.O. Box #1387
  _/  _/  _/   _/_/_/     _/      Beltsville, MD 20704-1387  USA
 _/      _/        _/    _/       Voice:301-210-1100  FAX:301-210-1131
_/      _/   _/_/_/   _/_/_/      Email: ggrieff_at_netcom.com
----------------------------------------------------------------------