Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Change Oracle schema passwords - any warnings....

Posted on 2012-03-09
3
Medium Priority
?
239 Views
Last Modified: 2012-04-03
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...
0
Comment
Question by:at999
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 16

Expert Comment

by:Walter Ritzel
ID: 37703654
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
 

Author Comment

by:at999
ID: 37703876
How can i use oracle sql developer to do this ? Do I have to run the same command - alter user... ?
0
 
LVL 16

Accepted Solution

by:
Wasim Akram Shaik earned 2000 total points
ID: 37704113
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

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question