Re: CREATE DATABASE WITH OWNER '??';

The Hermit Hacker writes:

> tables have owners .. right now, as far as I can tell, the database itself
> doesn't have an owner.

peter ~/pg-install/bin$ ./psql -lList of databasesDatabase  | Owner
-----------+-------peter     | petertemplate1 | peter
(2 rows)

> Unless I'm missing something, any user that can connect to a database
> can create new tables in that database, regardless of what they can do
> to the existing tables in that database ...

That is true, but IMHO schemas are are much better way to handle that.

-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden