How to disable a Redshift database user

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;    

See also  How to print only file names from an S3 bucket