You might want to temporarily or permanently disable a Redshift database user account. You can achieve this by changing the validity of the user password to a past date as shown below:
alter user username valid until '2020-01-01'; commit;
To re-enable the user account, change the valid until parameter to a future date or ‘infinity’ as shown below:
alter user username valid until '2025-01-01'; or alter user username valid until infinity;