• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 893
  • Last Modified:

Oracle 10g - dba_users table

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
joaotelles
Asked:
joaotelles
  • 2
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
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
 
joaotellesAuthor Commented:
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
 
slightwv (䄆 Netminder) Commented:
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
 
joaotellesAuthor Commented:
Tks
0
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.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now