Start Free Trial
Come for the solution, stay for everything else.
Start Free Trial
How to Reset oracle schema password
I have one particular Oracle Schema I'd like to reset the password to lock out users, callled, "XSHA". I have the current password, how can I reset that password? Thank you
8/22/2022 - Mon
if you want to unlock the user, then first
alter user xsha account unlock;
and then to reset the password
alter user xsha identified by password_value;
All the necessary information is in the docs..
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today
7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
If you want to lock out users you dont have to change the password; just lock using ;
alter user XSHA account lock;
then when finished your job you can unlock again by issuing command
alter user XSHA account unlock;
user may go on working with their existing password.
slightwv (䄆 Netminder)
>>lock out users
If this means you do not want other users to be able to access tables in that schema, the lock commands above will not do this.
Other schemas might have been granted privileges on the objects. Even if you lock the account and change the password, they can still access whatever they have been granted access on.
You will ned to revoke all access to completely keep people out.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
I didn't realize it was that easy to change that password. I did't have SQL plus installed, I did it from SQL developer. Thanks!
Plans and Pricing
Certified Expert Program
© 1996-2022 Experts Exchange, LLC. All rights reserved. Covered by US Patent