Re: how to set ownership of tables?

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: how to set ownership of tables?
Дата
Msg-id 200105221142.f4MBg8S29036@candle.pha.pa.us
обсуждение исходный текст
Ответ на how to set ownership of tables?  (bboett@erm1.u-strasbg.fr (Bruno Boettcher))
Список pgsql-sql
> Hello!
> 
> how can i change the ownership of a table? i have the problem that i
> create table with CONSTRAINTS on other tables, those others have a
> different owner... and thus the creation of the table is refused....
> 
> is it possible to make constraints on tables whithout having their
> ownership? is it possible to grant those rights?
> 
> or otherwise, how can i change the owenership of the concerned table?

7.1.X has ALTER TABLE ... OWNER.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: how to check presence of a function and set permissions?
Следующее
От: chris Günther
Дата:
Сообщение: query PostgreSQL from c++