Essbase 21c respository db schema passwords
SummaryThe Essbase schema passwords will expire in 360 days
I deployed Essbase 21c in OCI via the marketplace. I created an ATP instance in advance. The Essbase deployment uses the Repository Creation Utility to create the schemas Essbase needs in the database. I noticed that those schemas are using the default database profile. The password lifetime setting in that profile is 360, meaning the password will expire in 360 days.
What is the best practice for dealing with this? Is this something I need to be worried about? Will I need to change these passwords in a year? Should I change the schemas to use one of the profiles where password lifetime is unlimited? Does Essbase connect to the database with these schemas or does it use the database admin account specified during deployment?