"Andrus" <kobruleht2(at)hot(dot)ee> writes:
> ALTER DEFAULT PRIVILEGES IN SCHEMA public,firma1 GRANT all ON TABLES TO
> vantaa;
I am not sure that REASSIGN OWNED will get rid of default-privilege
specifiers --- you might have to reverse this step separately.
In general, REASSIGN OWNED has to be done by a role that has privileges
of (is a member of) both the source and target roles. Superusers are
considered members of all roles, so that's how come it works for them.
regards, tom lane