How to create service user in Oracle 9i
Let 's say I have one application for ex. name "app1", this application has a setting to connect to Oracle 9i using Database user for ex. name "db1". Because of this setting all users connect to app1 will use db1 as a user to connect to Oracle Database. This is perfectly working.
Unfortunately for security reason I need to setup password expiry for all database user : every every 90 days, with this setting everytime I have change this setting I need to
1. change db1 password
2. Reconfigure app1 setting with new db1 password.