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

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


change user profiles


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.


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