Results 1 to 7 of 7
  1. #1
    Join Date
    May 2006
    Posts
    8

    Unanswered: Creating A User Using Os Authentication

    hii friends,
    i was trying to connect user using os authentication .in parameter file i set the
    parameter OS_AUTHENT_PREFIX="" then i have created a user using sql then shut down the database and opened in nomount state but still i am not able to
    connect using os authentication.that created user was also belonging to os user

    so,please help me.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    OSUSER must equal Oracle Username.
    It works for me on *nix.
    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
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Shouldn't that Oracle user be created with prefix "OPS$"? For example, if OS user was 'scott', Oracle user should be "ops$scott'.

    Or am I talking about something completely irellevant?

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    > Oracle user should be "ops$scott'.
    Only if OS_AUTHENT_PREFIX="OPS$", but OP stated OS_AUTHENT_PREFIX=""
    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.

  5. #5
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Ah! Thank you!

  6. #6
    Join Date
    May 2006
    Posts
    8

    steps

    can u give me the steps what r the parameters i have to set and how to get connected with oracle using os authentication.

  7. #7
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    please visit http://asktom.oracle.com & do a keyword search on "OS_AUTHENT_PREFIX" & then proceed to read & learn the answer to your question.
    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.

Posting Permissions

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