Re: How to drop user if objects depend on it
От | Andrus |
---|---|
Тема | Re: How to drop user if objects depend on it |
Дата | |
Msg-id | BA4E670D8DF2441094B23737A03528E5@dell2 обсуждение исходный текст |
Ответ на | Re: How to drop user if objects depend on it (Melvin Davidson <melvin6925@gmail.com>) |
Ответы |
Re: How to drop user if objects depend on it
|
Список | pgsql-general |
Hi! >No. You need to be a superuser to reassign objects unless you own the >object. >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. Script reassign owned by farukkugay to postgres; drop user farukkugay ; is running by superuser but it still causes the error. >You must also be a superuser to drop roles. Non-superuser creates roles, assigns rights and drop users using scripts which I provided. Those scripts work OK on most cases. For some users, vantaa and farukkugan delete script causes error which I described. For farukkugan it occurs also if running under superuser. So it looks like it should be possible for non-superusers also. Andrus.
В списке pgsql-general по дате отправления: