Dropping default privileges.

From: Tim Uckun <timuckun(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Dropping default privileges.
Date: 2013-01-30 02:58:54
Message-ID: CAGuHJrOwG1X7JwPU=RqLVFG=FQ+DgNaQVKhdJ8i6kPVB=gi0BQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2013-01-30 03:27:00 Re: Dropping default privileges.
Previous Message Noah Misch 2013-01-30 01:51:55 Re: BUG #7493: Postmaster messages unreadable in a Windows console