scott/tiger problem

[mgl70]

hi,

I installed oracle database9i on linux machine. I did sqlnet configuration also. I am able to creating users through system/manager and I am able to go to sqlprompt and do my work. But I am not able to login as a scott/tiger by using this "sqlplus scott/tiger".

I donot know the problem is.

what I have to do for this.

need help.
thanks in advance

 

[carp]

Without the error message, it's hard to say what the problem is. For starters, have you granted CREATE SESSION to scott?

 

[SantaMufasa]

MGL,

The "SCOTT/TIGER" account setup is not necessarily automatic. To determine if the SCOTT account exists, log in to a SQL*Plus account that works (i.e., SYSTEM/MANAGER), then you can issue this SQL statement:

SELECT username from DBA_USERS;

This shows what accounts exist. Then, if you want to set up the SCOTT/TIGER account, Issue the following statement:

create user SCOTT identified by TIGER
default tablespace <put_tablespace_name_here>
temporary tablespace <put_tablespace_name_here>
quota <some_number> on <default_tablespace_name>;
grant connect, resource to SCOTT;

But this certainly does not create the sample tables that you may be used to seeing in the SCOTT/TIGER user account.

If that is what you are looking for, I'm certain we can find you a script to set up not only the account, but also its typical tables.

Mufasa
(aka Dave of Sandy, Utah, USA @ 21:55 (08Dec03) GMT, 14:55 (08Dec03) Mountain Time)

 

[mgl70]

hi,

Thank you very much for your immediate help.
scott user is there already. I gave grant command.It worked.
Right now I am able to login as scott/tiger.

thanks one more time.