You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Essbase 21c respository db schema passwords

Received Response
22
Views
5
Comments
edited Mar 19, 2021 6:13PM in Essbase 5 comments

Summary

The Essbase schema passwords will expire in 360 days

Content

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?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!