Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Set ATP DB password not to expire.

edited Apr 16, 2022 6:45AM in Autonomous Database 2 comments

Summary: We need to set the ATP DB password not to expire and when we attempt it we do not have the correct privileges and its states we must be sys but we do not have that password. Can we set the password to never expire


Content (required):

We attempted to do this and hit errors related to not being able to set these password properties at the PDB level granularity. Steps followed:

  1. Connect to the OCI ATP DB using SQL Developer or your method of choice and the Wallet_ATPCERTS.zip attached.
  2. Get the ATP DB ADMIN user profile:
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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