Postgres Pro
Downloads
Home   >   mailing lists

Re: Cannot delete role because it depends on "default privileges" - Mailing list pgsql-general

From Tom Lane
Subject Re: Cannot delete role because it depends on "default privileges"
Date
Msg-id 23791.1477058911@sss.pgh.pa.us
Whole thread Raw
In response to Re: Cannot delete role because it depends on "default privileges"  (Durumdara <durumdara@gmail.com>)
Responses Re: Cannot delete role because it depends on "default privileges"  (Durumdara <durumdara@gmail.com>)
List pgsql-general
Tree view 
Durumdara <durumdara@gmail.com> writes:
> The DB_X dropped, so I can't choose it as "actual database".
> I tried this in a neutral database:
>     drop owned by role_x;
> But nothing happened, the error is same.

The error you are reporting is describing default privileges that
exist in the *current* database.  You need to do DROP OWNED BY
in that database (and maybe other ones, but start there).

            regards, tom lane

pgsql-general by date:

Previous
From: Durumdara
Date:
Subject: Re: Cannot delete role because it depends on "default privileges"
Next
From: Durumdara
Date:
Subject: Re: Cannot delete role because it depends on "default privileges"