Follow

Anyone happen to know why I'd be able to connect to a given database as a given user (and even drop tables) despite doing REVOKE ALL _and_ REVOKE CONNECT for this user?

Revoking: paste.lgts.xyz/?f0cd1f10b47c8c

No workie: paste.lgts.xyz/?8439049048d918

omg ok Google

paste.lgts.xyz/?4fe3c32ab107f5

You don't get superuser for your safety but oh btw any and all accounts you create we're gunna default to a special snowflake superuser group that is essentially superuser but with a different name so none of the documentation you have will make any sense LOL

@swaggboi It is not working because the permission is not attached to the user (the permission is attached to the role and the user is defined within the role).

May I suggest some links to help you fix your problem.
- postgresql.org/message-id/00ce
- stackoverflow.com/a/42950174
- stackoverflow.com/a/49209238

Sign in to participate in the conversation
Ruby.social

A Mastodon instance for Rubyists & friends