Solved

Oracle 10g - dba_users table

Posted on 2010-11-18
4
837 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
[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
  • 2
  • 2
4 Comments
 
LVL 77

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 77

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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

695 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