Creating New Users with Password Control

CREATE USER IF NOT EXISTS nicole IDENTIFIED BY P@s%w0rd

PASSWORD EXPIRE INTERVAL 90 DAY

CREATE USER IF NOT EXISTS nicole IDENTIFIED BY P@s%w0rd

PASSWORD HISTORY 5

CREATE USER IF NOT EXISTS nicole IDENTIFIED BY P@s%w0rd PASSWORD REUSE INTERVAL 365 DAY

The Create User command also has the ability to enforce password rules