Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Posts
    43

    Question Unanswered: who's is logged on?

    I don't have dba writes on my Database but I need to know who is logged on, for a new development.

    How can I see who is logged on to the database any a point in time?
    I am using Oracle 9i..

  2. #2
    Join Date
    Nov 2003
    Location
    Rotterdam, Netherlands
    Posts
    127
    Ask your DBA to give Select permission for
    ALL_USERS table.
    or ask him to create a view out of it and grant permission.

    Otherwise not possible

  3. #3
    Join Date
    Oct 2003
    Posts
    37

    Re: who's is logged on?

    Hi

    I use v$session to see who is logged on at any point in time.

    Regards

    Keith

  4. #4
    Join Date
    Nov 2003
    Location
    Rotterdam, Netherlands
    Posts
    127
    Sorry i gave a wrong table name
    its not ALL_USERS

    Ask your dba to give permission for V$SESSION or create a view from it and give permission to it.

  5. #5
    Join Date
    Oct 2003
    Posts
    43

    thanks

    Just what I was after! thank you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •