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

    Question 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
    Posts
    2,825
    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
  •