DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: user priviliges

  1. #1
    Join Date
    Aug 2000
    Posts
    163

    Cool

    Hi DBA's,
    I am trying to investigate the following error:
    ORA-02063 user USER1 lacks CREATE SESSION privilege; logon denied
    I know before the user can create a session and do anything he/sqe has to have a 'create session' privilige. Please let me know what I need to do.
    Thank you.

  2. #2
    Join Date
    Jul 2000
    Posts
    296
    log on as SYSTEM and 'grant create session to user1;'.

  3. #3
    Join Date
    Aug 2000
    Posts
    163
    thanks

Posting Permissions

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


Click Here to Expand Forum to Full Width