Re: CREATE DATABASE WITH OWNER '??';

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: The Hermit Hacker <scrappy(at)hub(dot)org>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: CREATE DATABASE WITH OWNER '??';
Date: 2000-05-10 21:24:59
Message-ID: Pine.LNX.4.21.0005101835020.30279-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 -l
List of databases
Database | Owner
-----------+-------
peter | peter
template1 | 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(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2000-05-10 21:25:15 Re: setproctitle() no longer used?
Previous Message Lamar Owen 2000-05-10 20:25:07 Re: 7.0 RPM?