Solved

Oracle 10g - dba_users table

Posted on 2010-11-18
4
820 Views
Last Modified: 2012-06-27
Hi,

I have few users that connects to the database:

SQL> select username, user_id from dba_users;

USERNAME                          USER_ID
------------------------------ ----------
BOBJE                                  70
BOMDB                                  66
DPOWNERA_1A                            65
DPOWNERA                               64


I want to change the password of all of then.

How should I do it? Is it necessary to restart the database in order to the change to take effect?

Tks,
Joao
0
Comment
Question by:joaotelles
  • 2
  • 2
4 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 250 total points
ID: 34169031
Brute force:
Alter user bobje identified by newpassord;
Repeat for all users.


No need to restart database

You can write a pl/sql loop and use execute immediate but itk4 probably overkill.

If you just want to keep them out, lock the accounts:
Alter user bobje account lock;
0
 

Author Comment

by:joaotelles
ID: 34169093
Tks for the reply.

Is it 'best practice' to lock the accounts before the changes?

Like:
Alter user bobje account lock;
Alter user bobje identified by newpassord;

Tks
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34169159
Two different things.  Locking the account keeps them from being able to log in.

Changing the password is just that.  If they know the new one, they can log in.

They do different things.  I just threw out locking accounts because I couldn't see a need to change passwords on ALL accounts.
0
 

Author Closing Comment

by:joaotelles
ID: 34169186
Tks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
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 video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

867 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now