Solved

Change Oracle schema passwords - any warnings....

Posted on 2012-03-09
3
229 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 500 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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Database Design Dilemma 6 71
SYS password changed. Now can't log in as SYS 27 62
Error in creating a view. 8 52
Password_rules_securitty.. 12 46
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

752 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