Thread: how to set ownership of tables?
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? -- ciao bboett ============================================================== bboett@earthling.net http://inforezo.u-strasbg.fr/~bboett http://erm1.u-strasbg.fr/~bboett =============================================================== the total amount of intelligence on earth is constant. human population is growing....
> 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