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.

Received Response
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 attached.
  2. Get the ATP DB ADMIN user profile:

Howdy, Stranger!

Log In

To view full details, sign in.


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