Hi All,
I’m having some trouble removing users using the postgresql_user integration module, I accept that I’m probably doing something dumb.
To get rid of users, I realise I need to first get rid of their privileges. I successfully revoke table and sequence privileges
Unfortunately I’ve not figured out (or found out) how to remove privileges on views, which still kick around and prevent deletion or the user account
trying to delete the user manually shows:
drop user max;
ERROR: role “max” cannot be dropped because some objects depend on it
DETAIL: privileges for privileges for view best_test_view
any help with this would be great happy to provide more info if needed