Обсуждение: Little question on owners

Поиск
Список
Период
Сортировка

Little question on owners

От
Olivier PRENANT
Дата:
Hi  all!!

I'm testing 7.2b4 and I have this (little problem) when importing the
7.1.3 databases:

2 of the databases are owner by a gone user (not in the system
anymore) That gives errors when recreating databases.

I'd like to see this databases belong to me (that one was easy : change
sysuid in pg_databases); however, how do I change table owner, permissions
etc..

Regards

-- 
Olivier PRENANT             Tel:    +33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou           +33-5-61-50-97-01 (Fax)
31190 AUTERIVE                      +33-6-07-63-80-64 (GSM)
FRANCE                      Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)