removing a user who owns objects

Поиск
Список
Период
Сортировка
От Laurette Cisneros
Тема removing a user who owns objects
Дата
Msg-id Pine.LNX.4.44.0206121502230.11061-100000@visor.corp.nextbus.com
обсуждение исходный текст
Список pgsql-admin
What am I missing?

I want to remove a user who owns databases and objects.

I can change the owner of a database by updating the datdba field in
pg_database.

This allows me to drop the user!

However, the user still owns other objects. So, I have found that I also
need to fix ownership for:
pg_aggregate - aggowner
pg_class - relowner
pg_operator - oprowner
pg_proc - proowner
pg_type - typowner
in each database.

YET, I still have problems as my java program fails with an error:
"pg_aclcheck: invalid user id 111"

Is there something else I am missing?

Thanks for the help,

--
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
Where's my....bus?



В списке pgsql-admin по дате отправления:

Предыдущее
От: Felipe Nascimento
Дата:
Сообщение: Re: Help needed
Следующее
От: "Michael G. Martin"
Дата:
Сообщение: UnUsed Tuple Space Huge