Oracle User Scott not accessing

Asked By Will Turner 140 points N/A Posted on - 05/11/2011

Hi,

I am using Oracle to learn SQL. Just introductory. I downloaded the Oracle setup file from Oracle's homepage named – "oracleXE 10g". The software installed successfully, but I don't seem to find the user Scott, which was used in the class lecture. I missed the lecture so could not figure out if there was anything said which was not covered in the papers. I asked a partner who said it was a default user. Then why can't I access it? Do I need a configuration or something to be set up at the beginning? Or am I using the wrong version? The instructor said in the paper that it was 10g, are there any variance within 10g?

• Status: Open
• Question Views: 1509
• Answer Count: 6
• Vote Up 14 Vote Down

• Answer Accepted: Yes
• Question Category: Oracle Database

Best Answer by technical007

Go To Solution

Answered By technical007 0 points N/A #91839

Oracle User Scott not accessing

Scott user is not in the default user list bundled in Oracle XE. You have to create it manually or by running a script. Go here to download the script.

First of all, create a user named, Scott and password, Tiger or as you wish. Log into it and the run the script on your SQL command line.

About technical007

Questions
0

Answers
14

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 05/12/2011
• Question Category: Oracle Database

Answered By Will Turner 140 points N/A #91842

Oracle User Scott not accessing

Thanks for the answer. The link seems broken. Would you please post the link again?

About Will Turner

Questions
1

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 05/12/2011
• Question Category: Oracle Database

Answered By softwaresynthesis 0 points N/A #91844

Oracle User Scott not accessing

There is a script here, which shall create all the tables and data along with it: http://www.dbasupport.com/forums/showthread.php?34990.html. You have to create the user first manually.

About softwaresynthesis

Questions
0

Answers
25

Best Answers
6

• Vote Up 0 Vote Down

• Posted on - 05/12/2011
• Question Category: Oracle Database

Answered By Will Turner 140 points N/A #91845

Oracle User Scott not accessing

Thanks. I have created a user named Scott but it doesn't let me log in.

About Will Turner

Questions
1

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 05/12/2011
• Question Category: Oracle Database

Best Answer

Best Answer

Answered By technical007 0 points N/A #91846

Oracle User Scott not accessing

That is because you have to grant some permission to it. Here is a script that does everything, you shall find it in the 3rd post :

http://www.dbasupport.com/forums/showthread.php?34990.html

• Copy Script , save it in a text file, with extension " .sql ".   When done, open up the SQL command prompt.
• connect  sys as sysdba   and give password

If you already have a user named Scott, you may want to drop it first. Issue :

• drop user scott cascade
• Now enter the character  '@' the command prompt and drag and drop the scriptfile.sql you just created.
• Press enter.

It will take a while till your user is up and ready.

About technical007

Questions
0

Answers
14

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 05/12/2011
• Question Category: Oracle Database

Answered By Will Turner 140 points N/A #91847

Oracle User Scott not accessing

Thanks, technical007 and softwaresynthesis, both of you. I got my problem solved!

About Will Turner

Questions
1

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 05/12/2011
• Question Category: Oracle Database