Check default user account parameters

How to check the default profile parameters for Oracle database users: SELECT profile, resource_name, limit FROM dba_profiles WHERE profile=’DEFAULT’; The output from the query should look similar to this: Failed_login_attempts 10 Password_grace_time 7 (days) Password_life_time 180 Password_lock_time 1 (days) Password_reuse_max Unlimited Password_reuse_time Unlimited To modify any of these parameters, use…

Continue reading