Skip to content

Instantly share code, notes, and snippets.

@bigsnarfdude

bigsnarfdude/gist:05aa4c0555014ca86ef33d699557a08a

Last active July 18, 2023 14:07
Show Gist options
  • Save bigsnarfdude/05aa4c0555014ca86ef33d699557a08a to your computer and use it in GitHub Desktop.
Save bigsnarfdude/05aa4c0555014ca86ef33d699557a08a to your computer and use it in GitHub Desktop.
Download ZIP
delete users from redshift
Raw
gistfile1.txt
select * from "pg_namespace" ;
revoke select on all tables in schema main_production from user;
revoke usage on schema main_production from user;
revoke select on all tables in schema main_production from user;
revoke usage on schema main_production from user;
revoke all on all table in schema from user;
revoke all on all tables in schema from user;
drop user modeuser;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment