Results 1 to 7 of 7
  1. #1
    Join Date
    Oct 2011
    Posts
    6

    Unanswered: User management in 11g

    What are the default users , default roles, default profiles that will automatically created while creating a DB through DBCA ?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    What are the default users , default roles, default profiles that will automatically created while creating a DB through DBCA ?

    is SELECT broken for you?
    answer is Oracle version dependent & since you decided we did not need to know yours, no answer is possible
    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
    Oct 2011
    Posts
    6
    Thanq.

    Even after writing as below I am unable to login. It is showing invalid:

    > conn system/manager

    But if write as

    > conn scott/tiger

    It is connecting .... what is the reason ?

  4. #4
    Join Date
    Oct 2011
    Posts
    6
    If I write as ...

    >conn system/manager as sysdba

    it is connecting

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    please use COPY & PASTE for whole session
    It works OK for me.
    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.

  6. #6
    Join Date
    Oct 2011
    Posts
    6
    pls find the attachement
    Attached Thumbnails Attached Thumbnails sql.JPG  

  7. #7
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    SQL> conn CLUELESS/IRELLAVENT as sysdba

    above will work for you.

    >SQL> connect system/foobar
    >ERROR:
    >ORA-01017: invalid username/password; logon denied

    What part of above do you NOT understand?
    FWIW - With V11 passwords by default are CaSeSeNsitiVe!
    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
  •