Re: How to drop user if objects depend on it

[Melvin Davidson <melvin6925@xxxxxxxxx>]

No. You need to be a superuser to reassign objects unless you own the object.

You must also be a superuser to drop roles.

So.

1. first connect as user postgres

2. REASSIGN all the tables owned by the missing user first.

3. Then you can drop the missing user AFTER you have reassigned all the objects they own.

On Wed, Oct 7, 2015 at 10:48 AM, Andrus <kobruleht2@xxxxxx> wrote:

Hi!

Can you connect as user postgres? IE: psql -U postgres -d <yourdb>

Applicaton has admin users which should be able to delete other users.
Those users dont have superuser rights.

I can connect as user postgres for testing only.
I'm looking for a way to delete users without superuser right.

If so, then you should have the ability to execute the commands without any problem.

I tried in database ktp :

reassign owned by farukkugay to postgres;
drop user farukkugay ;

This causes error

ERROR:  role "farukkugay" cannot be dropped because some objects depend on it
DETAIL:  privileges for schema public

So even superuser cannot delete.

Andrus.

--

Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.