Skip to main content

Remediation

Password Rotation​

Using SQL​

The executing role must hold the OWNERSHIP privilege on the target user account to modify its properties via SQL.

  1. Reset the User Password:
ALTER USER {{username}} 
    SET PASSWORD = '{{new_password}}';
  1. Enforce Password Change on Next Login (Recommended):
ALTER USER <username> SET MUST_CHANGE_PASSWORD = TRUE;