Discussions
Categories
- 382.3K All Categories
- 2.1K Data
- 209 Big Data Appliance
- 1.9K Data Science
- 448K Databases
- 221K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 25 Multilingual Engine
- 520 MySQL Community Space
- 467 NoSQL Database
- 7.8K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 492 SQLcl
- 3.9K SQL Developer Data Modeler
- 186.2K SQL & PL/SQL
- 21K SQL Developer
- 293.3K Development
- 7 Developer Projects
- 128 Programming Languages
- 290K Development Tools
- 95 DevOps
- 3K QA/Testing
- 645.5K Java
- 24 Java Learning Subscription
- 36.9K Database Connectivity
- 149 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.9K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 16 Java Essentials
- 144 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 198 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 266 LiveLabs
- 36 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 166 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 230 Portuguese
Password changer in multiple database
Hi,
I am planning to have a functionality/procedure in the database that has the capability to change passwords on the database I am connected to and any other databases I have access to within the network. Is there a way for me to do this?
My current predicament is we are required to change the password in each environment we have IDs in every 60 days and this is quite laborious when I have access to 100+ instances.
TIA
Binoy
Answers
-
Binoy wrote: Hi, I am planning to have a functionality/procedure in the database that has the capability to change passwords on the database I am connected to and any other databases I have access to within the network. Is there a way for me to do this? My current predicament is we are required to change the password in each environment we have IDs in every 60 days and this is quite laborious when I have access to 100+ instances. TIA Binoy
use central password repository like OID or what ever Oracle calls their product these days.
-
Bonoy, products like OID are extra cost. If you need a free method I can offer two. First just create a sqlplus script that sets the necessary Oracle environment then connects to each instance in turn issuing an alter user identified by command. This is not very eloquent, but it works. It is easy to write and not that difficult to maintain.
- -
A second approach is to write a pl/sql stored procedure that performs the password alteration and install it in every database. Then you write a calling routine that performs a remote execution of the password routine. Because you are executing these password routines via a database link and have so many remote instances to access you will need to explicitly close the links after use.
- -
HTH -- Mark D Powell --
-
-
I use something simple like this for myself (at the sql plus command line) when I work at a shop with several instances.
-- usage: passwordchanger username oldpassword newpassword
connect &1/&[email protected]
alter user &1 identified by &3 replace &2;
connect &1/&[email protected]
alter user &1 identified by &3 replace &2;
connect &1/&[email protected]
alter user &1 identified by &3 replace &2;
connect &1/&[email protected]
alter user &1 identified by &3 replace &2;