GRANT

From: Joakim Bomelin <jbm(at)gronaverket(dot)se>
To: pgsql-general(at)postgresql(dot)org
Subject: GRANT
Date: 2001-05-10 09:45:25
Message-ID: 3AFA6335.F05DC009@gronaverket.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

  • Re: GRANT at 2001-05-10 12:54:49 from Michelle Murrain
  • Re: GRANT at 2001-05-10 14:55:48 from Tom Lane

Browse pgsql-general by date

  From Date Subject
Next Message Igor 2001-05-10 09:53:24 Re[2]: Vacuudb problem
Previous Message martin.chantler 2001-05-10 09:38:23 Re: ER diagrams