Postgres Pro
Downloads
Home   >   mailing lists

Re: CREATE DATABASE WITH OWNER '??'; - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: CREATE DATABASE WITH OWNER '??';
Date
Msg-id Pine.LNX.4.21.0005101835020.30279-100000@localhost.localdomain
Whole thread Raw
In response to Re: CREATE DATABASE WITH OWNER '??';  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: setproctitle() no longer used?
Next
From: Peter Eisentraut
Date:
Subject: Re: CREATE DATABASE WITH OWNER '??';