GRANT - Mailing list pgsql-general

From Joakim Bomelin
Subject GRANT
Date
Msg-id 3AFA6335.F05DC009@gronaverket.se
Whole thread Raw
Responses Re: GRANT  (Michelle Murrain <mpm@norwottuck.com>)
Re: GRANT  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi.
I have currently changed from MySQL to PostgreSQL, and there is one
thing I'm not really getting...
When I create a new databse (with creatbd), all users are able to create
tables in this database. They are, how ever, not able to execute
commands on one another's tables, unless there are privileges set.
In MySQL I am able to set privileges on databases so user Ben can't
access user Stephen's database, but I can't work that out in pgsql. Is
it just me, or is GRANT only working for tables?

Thanks in advance.

--
Joakim Bomelin
Gröna Verket AB
040-691 91 36

pgsql-general by date:

Previous
From: Marc SCHAEFER
Date:
Subject: ER diagrams
Next
From: martin.chantler@convergys.com
Date:
Subject: Re: ER diagrams