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}}';

2. Enforce Password Change on Next Login (Recommended):

   ALTER USER {{username}} SET MUST_CHANGE_PASSWORD = TRUE;