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

Manage Oracle DB users

To manage an Oracle DB user account use the commands listed below. Change user account password:ALTER USER username IDENTIFIED BY new_password; Lock and unlock a user account:ALTER USER username ACCOUNT UNLOCK;ALTER USER username ACCOUNT UNLOCK; Force user to change password at next logon:ALTER USER username PASSWORD EXPIRE; Drop a user…

Continue reading