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

ATP User Profiles

edited Apr 16, 2022 7:54AM in Autonomous Database 2 comments

Summary

change user profiles

Content

hi all 

when i log with the admin user in atp i does not allow to change or create a new profile 

is there a way to create a profile in order not to expire the passwords for some users . when i connect with admin and tried

alter profile "DEFAULT" limit  password_life_time unlimited;

ORA-01031: insufficient privileges
01031. 00000 -  "insufficient privileges"
*Cause:    An attempt was made to perform a database operation without
           the necessary privileges.
*Action:   Ask your database administrator or designated security
           administrator to grant you the necessary privileges

so the same for create profile "NoPassword" 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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