Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Location
    Detroit, MI
    Posts
    17

    List accounts with SQLplus

    How can I get a listing of all the accounts defined for my database?

    Thanks,
    Jamin

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Desc dba_users;
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  3. #3
    Join Date
    Jan 2004
    Location
    India
    Posts
    191
    user_users ( list users from your schema)
    all_users ( list users plus users having acces to ur schema)
    dba_users ( list all users from ur database)
    Pagnint
    (No need to search web before posting new question)

  4. #4
    Join Date
    Jan 2004
    Location
    Detroit, MI
    Posts
    17
    Thanks!

Posting Permissions

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