Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2008
    Posts
    11

    Unanswered: User ID/Password

    Is there any system view which gives the status of a user in Oracle ?

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    What do you call a "status of Oracle user"?

    Besides, what does topic title has to do with actual question? ("status" vs. "User ID/Password")

  3. #3
    Join Date
    Apr 2008
    Posts
    28
    Hi,

    query DBA_USERS for user information
    or V$SESSION for logged in user sessions information.

  4. #4
    Join Date
    Jan 2003
    Posts
    3
    Test TEST TEST

  5. #5
    Join Date
    Mar 2008
    Location
    Seattle
    Posts
    11
    Looks like it worked...

    But yeah, account_status in dba_users will tell you the status of a user in the database.

Posting Permissions

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