Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    Germany
    Posts
    9

    Question Unanswered: how to check if a user name is valid?

    Hello!
    Is there a way to figure out if a given name a valid oracle login is?
    Something like:
    Select login From oracleusers Where login = 'SCOTT';
    ???

  2. #2
    Join Date
    Jan 2004
    Posts
    370
    select username from dba_users where username='SCOTT';

  3. #3
    Join Date
    Nov 2003
    Location
    Germany
    Posts
    9

    Smile

    Thank you very much SkyWriter for your quick help. It works fine :-)

Posting Permissions

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