Change Oracle schema passwords - any warnings....

I have oracle 11 r2 database on a linux box

I connect to that database using sqlplus from my windows 7 box...

I have to change the password of an  Oracle schema -mytestschema in my oracle 11r2 database.  
In that database I have another schema - mydbauser is of the type DBA

I will log in using mydbauser and i will execute this command -
alter user mytestschema identified by newpassword

Do I have to do any thing else to change the password,  like run any commands etc?

Do I have any warnings/ important things I should consider before changing the password...

i need the advice...


thanks a lot...
at999Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Walter RitzelSenior Software EngineerCommented:
The only thing I can tell is: do you have any apps that uses the database? If yes, you need to change on those apps as well.

And a suggestion: if you access your database always from windows, use Oracle SQL Developer. It makes these things as administer users an easy thing.
0
at999Author Commented:
How can i use oracle sql developer to do this ? Do I have to run the same command - alter user... ?
0
Wasim Akram ShaikCommented:
dont worry about oracle sql developer, its pretty much does the same thing, but has a good visual and GUI when compared to SQL*PLUS, its just a tool..

yes, you have to run the same command..

Its your database, if you want to have customized warnings, then you can set it on..

as expert said, the most important thing to be considered is to inform all the applications which are connecting to that schema for data access, if they are not aware of what you do, lot of chaos will occur..!!!
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.