From: | Dado Feigenblatt <dado(at)wildbrain(dot)com> |
---|---|
To: | postgres mailinglist <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Database permissions |
Date: | 2001-12-07 17:02:14 |
Message-ID: | 3C10F616.5070202@wildbrain.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Tommi Mäkitalo wrote:
> Hi,
>
> I would like to create permissions on databases. I have a server,
> where different applications from different accounts use my database.
> It would be nice, if a user can access his database, but not the
> others. I know, that I can set up table-permissions, but no database
> permissions. It seems not to be possible to prevent users creating
> tables in wrong databases.
>
> I have followed the development of postgresql and read some mails in
> the mailinglist. There was a discussion about 'Granting Permissions to
> User To Access Database', but this was in january 2001 and it seems,
> that nothing has happend.
>
> I would like to be able to set 'revoke all on database from username'.
> Am I the only one, who needs this?
>
> In mysql there are chances to set permissions on database. It is the
> only feature, wich I found until now, which mysql does better than
> postgresql.
>
>
> Tommi Mäkitalo
>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
Have you looked at pg_hba.conf at all?
There you can setup which user, from which machine, conect to which
database.
--
Dado Feigenblatt Wild Brain, Inc.
Technical Director (415) 216-2053
dado(at)wildbrain(dot)com San Francisco, CA.
From | Date | Subject | |
---|---|---|---|
Next Message | Doug McNaught | 2001-12-07 17:07:40 | Re: Using Cursor in PostgreSQL 7.2 |
Previous Message | John James | 2001-12-07 16:15:28 | aggregation function |