Results 1 to 4 of 4

Thread: user name list

  1. #1
    Join Date
    Mar 2004
    Posts
    20

    Unanswered: user name list

    hi

    i want to get all the user names list in the database. is there any single query to retrive this ..


    john

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    take a look at dba_users view or all_users view ..

  3. #3
    Join Date
    Feb 2004
    Location
    India
    Posts
    135
    Check this Query:

    SELECT * FROM ALL_USERS ;

  4. #4
    Join Date
    Mar 2004
    Posts
    20

    thanks

    thanks for ur query Mr. Saravanan

Posting Permissions

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