Skip to content

Instantly share code, notes, and snippets.

@yujihamaguchi

yujihamaguchi/gist:4e107ec6998b8f30e5b9

Created January 9, 2015 01:30
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save yujihamaguchi/4e107ec6998b8f30e5b9 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save yujihamaguchi/4e107ec6998b8f30e5b9 to your computer and use it in GitHub Desktop.
Download ZIP
[Redshift] ユーザが削除できない時に試す処置
Raw
gistfile1.sql
REVOKE ALL ON DATABASE {db name} FROM {user id} CASCADE;
REVOKE ALL ON SCHEMA {schema name 1} FROM {user id} CASCADE;
REVOKE ALL ON SCHEMA {schema name 2} FROM {user id} CASCADE;
...
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment