The ALTER USER statement can be used by a DBA to change a user's password directly. Similarly, the SET PASSWORD statement is specifically designed to set or reset user passwords. These methods are standard for managing user authentication in many database systems.