On 2000-01-21, Neil Cameron mentioned:
> 1. How can I change a database object's owner using SQL type commands ?
With update. For example:
UPDATE pg_class SET relowner = <userid> WHERE relname = 'my_table';
> 2. Users seem by default to be able to create tables. Is this correct.
> If so how can we remove this right.
Yes and you can't.
--
Peter Eisentraut Sernanders väg 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden