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

    Unanswered: ORA-01936: cannot specify owner when creating users or roles

    Setup: 9iDB

    I am trying to create a user with a name of 'first.mi.last'. Oracle is returning ORA-01936: cannot specify owner when creating users or roles. I guess it is because of the inline periods. Is there any way around this?
    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
    Not sure WHY but here is how you can do it.

    create user "FIRST.MI.LAST" identified by password default tablespace tools temporary tablespace temp
    SQL> /

    User created.
    Of course you'll have to always use the double quote marks to reference any object owned by this schema.
    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
    Thanks. Luckily there will not be creating any objects. Good point to remember.

    I take back what I said about you earlier, you are not "one of the greatest" you ARE the greatest. (Sorry Duck, billm, Skywriter, andrewst and the rest of you great people out there).
    NOTE: Please disregard the label "Senior Member".

  4. #4
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    My guess on the WHY is that Oracle does some parsing on the id + other info (ie. first.mi.last.owner.profile etc.) separating on a . character expecting a certain number of fields. Enclosing the id in quotes ("first.mi.last".owner.profile) returns the correct number of fields expected.
    NOTE: Please disregard the label "Senior Member".

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    OWNER.PACKAGE.PROCEDURE
    /
    is valid SQL
    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
  •