Skip to content

role ... cannot be dropped because some objects depend on it

Posted by Andreas 'ads' Scherbaum on
I want to drop a ROLE (previously USER/GROUPs) which is still referenced by object(s) in my database. But PostgreSQL has objections:

ERROR: role "xyz" cannot be dropped because some objects depend on it
DETAIL: access to schema public

Continue reading "role ... cannot be dropped because some objects depend on it"