Re: password for sql plus

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 373,502 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,837 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Oracle advertiser:

password for sql plus

•

Join Date: Feb 2007

Location: Bangalore,India

Posts: 1,172

Reputation: debasisdas is an unknown quantity at this point

Rep Power: 4

Solved Threads: 75

debasisdas debasisdas is offline

Offline

Veteran Poster

Re: password for sql plus

Jun 6th, 2007

When oracle is installed it creates a number user almost 20.
At the time of installation except the DBA accounts all others are LOCKED by default.
Which can be unlocked at the time of installation orlater on by logging in through the DBA accounts.

In your case it seems SCOTT account is locked.

u can login as SYS/AS SYSDBDA

then unlock the scott account
by

alter user scott identified by tiger account unlock;

Hope that helps u in solving your problem.

Forum Highlights

Related Features

DANIWEB FEATURE INDEX

Statistics

Members: 373,502

Users Online Now: 3,837

Active IRC Users: 17

Forum Threads: 123,450

Forum Posts: 638,925

Code Snippets: 849

Blogs: 139

Blog Entries: 1,950

Directory Links: 563

DaniWeb Home > Forums > Web Development > Databases > Oracle > password for sql plus

Re: password for sql plus

password for sql plus

Re: password for sql plus