Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467

    Unanswered: Oracle/Forms users with periods in their username

    Setup: Forms 9i, 9iDB

    When my app launches I connect as a default user and then present a login screen for the real user. If that user has a username like "Todd" I can reconnect them and then launch the first form with OPEN_FORM('operations', ACTIVATE, SESSION, 'default');

    However if the username is "Todd.Barkus" I can still connect as long I enclose the username in double quotes put when I call open_form as above I receive "ORA-01017: invalid usernmame/login; login denied" the form then opens and I recieve the error "FRM-41352: Failed to create session" (which is probably meaningless).

    Has anyone deployed a system using periods in user names?

    Any idea what the problem is?
    NOTE: Please disregard the label "Senior Member".

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    It is generally a BAD IDEA to use non-standard characters in names of Oracle objects. Your life will be MUCH easier if you use the underscore
    character "_" in place of the period. I previously warned you that by
    using a period within a username that the username would have to be enclosed within double quote marks every time is needs to be used.
    You're On Your Own (YOYO)!
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    I am aware of your previous warning and I have insured that the username in always in ".

    But thanks for the input anyway.
    NOTE: Please disregard the label "Senior Member".

Posting Permissions

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