Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Create session needed

Status
Not open for further replies.
mflower

mflower

MIS
May 6, 2001
52
NZ
I've created a user and password, but now Oracle requests for "Create session..." needed before I can use this user/password to login. Why? and how to fix this?
 
Sort by date Sort by votes
Grant "Create Session" privilege to the user or grant the "Connect" role. The reason is obvious.

GRANT CONNECT TO user1;

Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Tsmtbo2011
  • Locked
  • Question
Help Needed!! Micros WS6 610
Replies
1
Views
102
carp
carp
lella2015
  • Locked
  • Question
Understanding Parallel hints on Tables and parallels in Create table as well.
Replies
0
Views
55
lella2015
lella2015
estersita
  • Locked
  • Question
Trying to create a new filed on the flue based on the existing one
Replies
1
Views
64
Beilstwh
Beilstwh
tekpr00
  • Locked
  • Question
Database Session Connection Audit - LOG_OFF_TIME 1
Replies
3
Views
85
Beilstwh
Beilstwh
scb1776
  • Locked
  • Question
create table command fails when user has create table privilege
Replies
9
Views
106
SantaMufasa
SantaMufasa

Part and Inventory Search

Sponsor

Back
Top