Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2008
    Posts
    21

    Red face Unanswered: problem creating a user

    i am new to oracle. i am facing trouble in creating a new user. i create a user. but i cant login with that user name and password. the oracle prevent mefrom login. it says that the user doesnt have session permission. i am left in no where. does any one know wht is the prob?

    thanks in advance. and sorry for my english, i am not goot at it.
    take care and bye.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Grant Session To New_user;
    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
    Dec 2007
    Posts
    253
    Quote Originally Posted by anacedent
    Grant Session To New_user;
    Deliberate error ana?

  4. #4
    Join Date
    Feb 2008
    Posts
    21

    grant SESSION to user?

    grant session to user; this sql command doesnt work. i am trying to learn oracle by using command line interface. i am using 10g express edition. how can i give access to user to create sessions?

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Grant create Session To New_user;

    The complete Oracle documentation set can be found at http://tahiti.oracle.com

    You should practice RTFM to find your own answers.
    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
  •