Dropping default privileges. - Mailing list pgsql-general

From Tim Uckun
Subject Dropping default privileges.
Date
Msg-id CAGuHJrOwG1X7JwPU=RqLVFG=FQ+DgNaQVKhdJ8i6kPVB=gi0BQ@mail.gmail.com
Whole thread Raw
Responses Re: Dropping default privileges.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I am unable to drop a user.

drop role tim;
ERROR:  role "tim" cannot be dropped because some objects depend on it
DETAIL:  owner of default privileges on new relations belonging to
role tim in schema strongmail

ALTER DEFAULT PRIVILEGES IN SCHEMA strongmail
    REVOKE INSERT, SELECT, UPDATE, DELETE, TRUNCATE, REFERENCES,
TRIGGER ON TABLES
    FROM tim;

drop role tim;
ERROR:  role "tim" cannot be dropped because some objects depend on it
DETAIL:  owner of default privileges on new relations belonging to
role tim in schema strongmail

reassign owned by tim to postgres;

Nothing seems to work.


pgsql-general by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Optimizing select count query which often takes over 10 seconds
Next
From: Tom Lane
Date:
Subject: Re: Dropping default privileges.