Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2007

    Question Unanswered: Query to get list of Oracle Users

    I need to get the list of users of Oracle 10g using a Query... can somebody tell me how to do it?

    Thanks a lot!

  2. #2
    Join Date
    Nov 2003
    Provided Answers: 23
    If you mean active (= connected) users, then check out the view v$session

    If you mean users that are defined (= "accounts") then check out the view dba_users

Posting Permissions

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