From: | Ertan Küçükoğlu <ertan(dot)kucukoglu(at)1nar(dot)com(dot)tr> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | RE: Eror while dropping a user |
Date: | 2018-08-03 21:33:12 |
Message-ID: | 001201d42b71$951cabd0$bf560370$@1nar.com.tr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> From: Alessandro Aste <alessandro(dot)aste(at)gmail(dot)com>
> Sent: Saturday, August 4, 2018 12:02 AM
> To: Ertan Küçükoğlu <ertan(dot)kucukoglu(at)1nar(dot)com(dot)tr>
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: Eror while dropping a user
>
> You can run this query to itendify the relations owned by the users you're not allowed to drop,
> just replace ('<your_user_name_to_check>', 'username2' ..'userN' ) with the your role names .
> Then, once you have identified the tables/objecst change the owner like this:
I tried to run it on "postgres" database and "pars" database, schemas on pars database, etc. All return empty results.
Thanks anyway.
Regards,
Ertan
From | Date | Subject | |
---|---|---|---|
Next Message | Ertan Küçükoğlu | 2018-08-03 21:46:26 | RE: Eror while dropping a user |
Previous Message | Michael Paquier | 2018-08-03 21:04:27 | Re: Sv: WAL-dir filling up with wal_level = logical |