Skip to content

Instantly share code, notes, and snippets.

@moraisaugusto

moraisaugusto/drop_role.sql

Created August 1, 2019 08:09
Show Gist options
  • Save moraisaugusto/3d16ee17ce2e8fdfc5fda32c3171c53a to your computer and use it in GitHub Desktop.
Save moraisaugusto/3d16ee17ce2e8fdfc5fda32c3171c53a to your computer and use it in GitHub Desktop.
Download ZIP
Remove user/role from Postgres
Raw
drop_role.sql
REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA public FROM username;
REVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public FROM username;
REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA public FROM username;
DROP USER username;
DROP ROLE username;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment