Set ATP DB password not to expire.
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
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:
- Connect to the OCI ATP DB using SQL Developer or your method of choice and the Wallet_ATPCERTS.zip attached.
- Get the ATP DB ADMIN user profile: