Re: Managing Users - Mailing list pgsql-general

From Emmanuel SARACCO
Subject Re: Managing Users
Date
Msg-id 3BCBE38F.1070203@noos.fr
Whole thread Raw
In response to Managing Users  (Chris Cameron <ccameron@powersurfr.com>)
List pgsql-general
hi,

do you modified your [postgresql directory]/data/pg_hba.conf and
pg_ident.conf in order to limit access to this database?

bye

Chris Cameron wrote:

> I'm having a bit of a problem managing users.
>
> I have a database owned by user joe. Joe has a bunch of tables in this
> database and is allowed to create databases but not users. All the
> tables are owned by joe.
> If I create another user without any privledges at all, that user is
> able to (on my system) create tables in any existing databases.
> Including joes database.
>
> Do I have something improperly configured, or is this just the way
> Postgres works? I realize I have little details, but I'm not entirely
> sure whats causing this so I don't know what details to include.
>
> Thanks,
> Chris
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
>



--
Emmanuel SARACCO
Email: esaracco@noos.fr


pgsql-general by date:

Previous
From: "Eric Ridge"
Date:
Subject: Sorting by parent/child relationships
Next
From: David Link
Date:
Subject: Re: Easy way of pruning pg_data?