I need to find out if there is a view for a user who is not a sys to find out his sid, serial#. Is there a view that does what the v$session does. I'm trying to find out a way without having to grant privliages to this view. Sorry for the bad grammer but I'm in a hurry.
Thanks
Jason