Board index » delphi » Create new instance (user) in oracle - newbie

Eitan Mizrahi

Delphi Developer
Tue, 16 Dec 2003 02:14:41 GMT

Create new instance (user) in oracle - newbie

Hello,

I want to create a new instance in Oracle.
I connected as system/manager to the database via sql-plus.
I entered the line :
create user user_name identified by user_password
then I do exit and connect by using the new user_name+password.
I get an error message :
"ORA-01045: user user_name lacks CREATE SESSION privilege; logon denied".

How can I solve the problem.

Thanks :o)

 
Nikita Ievle

Delphi Developer
Tue, 16 Dec 2003 18:47:22 GMT

Re:Create new instance (user) in oracle - newbie


Quote
"Eitan Mizrahi" <eit...@e-ntouch.com> wrote in message

news:3b3b65df_1@dnews...

Quote
> Hello,

> I want to create a new instance in Oracle.
> I connected as system/manager to the database via sql-plus.
> I entered the line :
> create user user_name identified by user_password
> then I do exit and connect by using the new user_name+password.
> I get an error message :
> "ORA-01045: user user_name lacks CREATE SESSION privilege; logon denied".

Just grant the CREATE SESSION privilege to the newly created user :-) And
where is your DBA?

Best regards,
Nikita

John Pierc

Delphi Developer
Wed, 17 Dec 2003 01:47:58 GMT

Re:Create new instance (user) in oracle - newbie


Quote
Nikita Ievlev wrote:
> "Eitan Mizrahi" <eit...@e-ntouch.com> wrote in message
> news:3b3b65df_1@dnews...
> > Hello,

> > I want to create a new instance in Oracle.

Be sure you understand the difference between a user and an instance or you'll
be in BIG trouble.  Have a look at roles if you're going to create new users
with the same/similar privileges.

John PIerce

Other Threads

1. create a new oracle user

2. Oracle 7 and D4 create a new user

3. help - create new oracle user with d4

4. Oracle Sessions Parameter - Program Instances - User Licences

5. Creating a new instance of TBUTTON

6. CREATE: New Instance?

7. Creating a new instance

8. Connecting to Word97 without creating a new instance

9. creating new instance of class

10. Access error when creating new instance of a form from a package