Krishna Agnihotri wrote:If you want to change the password of a custom schema (database user) then you can simply use the "alter user" command.
We are using 126.96.36.199 DB with EBS R12.1.2. We have few Custom Database users (XX_CUSTOM) which is used in Concurrent program/reports/Discoverer/portal. Now for security reasons we want to change password of those users. (this is first time when we will change after installation). we are not sure what will be implact of changins password on custom forms/reports as many places password is hard-coded.
Can some one advice us what is the standard methos to change password for such users. and what tables backup we need to take before proceed.
select * from dba_users where username='XX_CUSTOM'; returns one row.
Secure Configuration Guide for Oracle E-Business Suite Release 12 [ID 403537.1] -- Page 10, CHANGE DEFAULT INSTALLATION PASSWORDS (3. Schemas belonging to optional database features used but not patched by E-Business Suite)
SQL> alter user XX_CUSTOM identified by '<new password>';