pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedproblems with user rights
9+ messages / 4 participants
[nested] [flat]
* problems with user rights
@ 2005-03-28 13:32 Zouari Fourat <fourat@gmail.com>
2005-03-30 08:43 ` Re: problems with user rights Zouari Fourat <fourat@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Zouari Fourat @ 2005-03-28 13:32 UTC (permalink / raw)
To: pgsql-admin
Hello,
i've just added a new user called xxx :
create user xxx with password zzz;
now am creating it's database :
create database db_xxx with owner xxx;
it works fine althought when logging with the user xxx i can still
view other databases contents especially pg_catalog schems.
is it the right way to add a user ? am i wrong ?
i dont want to let my new user view the others databases on the server.
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: problems with user rights
2005-03-28 13:32 problems with user rights Zouari Fourat <fourat@gmail.com>
@ 2005-03-30 08:43 ` Zouari Fourat <fourat@gmail.com>
2005-03-30 13:04 ` Re: problems with user rights John DeSoi <desoi@pgedit.com>
0 siblings, 1 reply; 9+ messages in thread
From: Zouari Fourat @ 2005-03-30 08:43 UTC (permalink / raw)
To: pgsql-admin
no one can help me over here ?
On Mon, 28 Mar 2005 15:32:32 +0200, Zouari Fourat <fourat@gmail.com> wrote:
> Hello,
> i've just added a new user called xxx :
>
> create user xxx with password zzz;
>
> now am creating it's database :
>
> create database db_xxx with owner xxx;
>
> it works fine althought when logging with the user xxx i can still
> view other databases contents especially pg_catalog schems.
>
> is it the right way to add a user ? am i wrong ?
> i dont want to let my new user view the others databases on the server.
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: problems with user rights
2005-03-28 13:32 problems with user rights Zouari Fourat <fourat@gmail.com>
2005-03-30 08:43 ` Re: problems with user rights Zouari Fourat <fourat@gmail.com>
@ 2005-03-30 13:04 ` John DeSoi <desoi@pgedit.com>
2005-03-30 15:17 ` Re: problems with user rights Zouari Fourat <fourat@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: John DeSoi @ 2005-03-30 13:04 UTC (permalink / raw)
To: Zouari Fourat <fourat@gmail.com>; +Cc: pgsql-admin
> i've just added a new user called xxx :
>
> create user xxx with password zzz;
>
> now am creating it's database :
>
> create database db_xxx with owner xxx;
>
> it works fine althought when logging with the user xxx i can still
> view other databases contents especially pg_catalog schems.
>
> is it the right way to add a user ? am i wrong ?
> i dont want to let my new user view the others databases on the server.
Viewing the information in the system catalogs is open to all users.
There is not a way to hide it unless you build an interface on top of
PostgreSQL that limits the queries the user can execute.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: problems with user rights
2005-03-28 13:32 problems with user rights Zouari Fourat <fourat@gmail.com>
2005-03-30 08:43 ` Re: problems with user rights Zouari Fourat <fourat@gmail.com>
2005-03-30 13:04 ` Re: problems with user rights John DeSoi <desoi@pgedit.com>
@ 2005-03-30 15:17 ` Zouari Fourat <fourat@gmail.com>
2005-03-30 16:14 ` Re: problems with user rights John DeSoi <desoi@pgedit.com>
0 siblings, 1 reply; 9+ messages in thread
From: Zouari Fourat @ 2005-03-30 15:17 UTC (permalink / raw)
To: John DeSoi <desoi@pgedit.com>; +Cc: pgsql-admin
is it really secure in a shared hosting environnement case ?
do you advise me to offer pgsql in a shared hosting ?
On Wed, 30 Mar 2005 08:04:00 -0500, John DeSoi <desoi@pgedit.com> wrote:
> > i've just added a new user called xxx :
> >
> > create user xxx with password zzz;
> >
> > now am creating it's database :
> >
> > create database db_xxx with owner xxx;
> >
> > it works fine althought when logging with the user xxx i can still
> > view other databases contents especially pg_catalog schems.
> >
> > is it the right way to add a user ? am i wrong ?
> > i dont want to let my new user view the others databases on the server.
>
> Viewing the information in the system catalogs is open to all users.
> There is not a way to hide it unless you build an interface on top of
> PostgreSQL that limits the queries the user can execute.
>
> John DeSoi, Ph.D.
> http://pgedit.com/
> Power Tools for PostgreSQL
>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: problems with user rights
2005-03-28 13:32 problems with user rights Zouari Fourat <fourat@gmail.com>
2005-03-30 08:43 ` Re: problems with user rights Zouari Fourat <fourat@gmail.com>
2005-03-30 13:04 ` Re: problems with user rights John DeSoi <desoi@pgedit.com>
2005-03-30 15:17 ` Re: problems with user rights Zouari Fourat <fourat@gmail.com>
@ 2005-03-30 16:14 ` John DeSoi <desoi@pgedit.com>
2005-03-30 16:43 ` Re: problems with user rights Scott Marlowe <smarlowe@g2switchworks.com>
2005-03-30 16:47 ` Re: problems with user rights Michael Fuhr <mike@fuhr.org>
0 siblings, 2 replies; 9+ messages in thread
From: John DeSoi @ 2005-03-30 16:14 UTC (permalink / raw)
To: Zouari Fourat <fourat@gmail.com>; +Cc: pgsql-admin
On Mar 30, 2005, at 10:17 AM, Zouari Fourat wrote:
> is it really secure in a shared hosting environnement case ?
> do you advise me to offer pgsql in a shared hosting ?
You can do all of the necessary things to control access to the
databases. You just can't hide that they exist if you provide a way to
directly query the database. There are may companies providing shared
hosting. I'm not aware of any security issues.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: problems with user rights
2005-03-28 13:32 problems with user rights Zouari Fourat <fourat@gmail.com>
2005-03-30 08:43 ` Re: problems with user rights Zouari Fourat <fourat@gmail.com>
2005-03-30 13:04 ` Re: problems with user rights John DeSoi <desoi@pgedit.com>
2005-03-30 15:17 ` Re: problems with user rights Zouari Fourat <fourat@gmail.com>
2005-03-30 16:14 ` Re: problems with user rights John DeSoi <desoi@pgedit.com>
@ 2005-03-30 16:43 ` Scott Marlowe <smarlowe@g2switchworks.com>
1 sibling, 0 replies; 9+ messages in thread
From: Scott Marlowe @ 2005-03-30 16:43 UTC (permalink / raw)
To: John DeSoi <desoi@pgedit.com>; +Cc: Zouari Fourat <fourat@gmail.com>; pgsql-admin
On Wed, 2005-03-30 at 10:14, John DeSoi wrote:
> On Mar 30, 2005, at 10:17 AM, Zouari Fourat wrote:
>
> > is it really secure in a shared hosting environnement case ?
> > do you advise me to offer pgsql in a shared hosting ?
>
> You can do all of the necessary things to control access to the
> databases. You just can't hide that they exist if you provide a way to
> directly query the database. There are may companies providing shared
> hosting. I'm not aware of any security issues.
My preferred way to setup accecss is to use the sameuser setting in
pg_hba.conf, which lets a user only connect to the database of their
name. Nicely partitions the server with minimum configuration needed.
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: problems with user rights
2005-03-28 13:32 problems with user rights Zouari Fourat <fourat@gmail.com>
2005-03-30 08:43 ` Re: problems with user rights Zouari Fourat <fourat@gmail.com>
2005-03-30 13:04 ` Re: problems with user rights John DeSoi <desoi@pgedit.com>
2005-03-30 15:17 ` Re: problems with user rights Zouari Fourat <fourat@gmail.com>
2005-03-30 16:14 ` Re: problems with user rights John DeSoi <desoi@pgedit.com>
@ 2005-03-30 16:47 ` Michael Fuhr <mike@fuhr.org>
2005-03-31 10:06 ` Re: problems with user rights Zouari Fourat <fourat@gmail.com>
1 sibling, 1 reply; 9+ messages in thread
From: Michael Fuhr @ 2005-03-30 16:47 UTC (permalink / raw)
To: John DeSoi <desoi@pgedit.com>; +Cc: Zouari Fourat <fourat@gmail.com>; pgsql-admin
On Wed, Mar 30, 2005 at 11:14:38AM -0500, John DeSoi wrote:
> On Mar 30, 2005, at 10:17 AM, Zouari Fourat wrote:
>
> >is it really secure in a shared hosting environnement case ?
> >do you advise me to offer pgsql in a shared hosting ?
>
> You can do all of the necessary things to control access to the
> databases.
...like using pg_hba.conf to control who's allowed to connect to
each database. If you don't want people to query the system catalogs
for a particular database, then don't allow them to connect to that
database (there are a few shared catalogs that anybody can query,
however).
The db_user_namespace configuration variable might help with managing
access, but the documentation says that it's "intended as a temporary
measure until a complete solution is found," so caveat administrator.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: problems with user rights
2005-03-28 13:32 problems with user rights Zouari Fourat <fourat@gmail.com>
2005-03-30 08:43 ` Re: problems with user rights Zouari Fourat <fourat@gmail.com>
2005-03-30 13:04 ` Re: problems with user rights John DeSoi <desoi@pgedit.com>
2005-03-30 15:17 ` Re: problems with user rights Zouari Fourat <fourat@gmail.com>
2005-03-30 16:14 ` Re: problems with user rights John DeSoi <desoi@pgedit.com>
2005-03-30 16:47 ` Re: problems with user rights Michael Fuhr <mike@fuhr.org>
@ 2005-03-31 10:06 ` Zouari Fourat <fourat@gmail.com>
2005-03-31 17:59 ` Re: problems with user rights Michael Fuhr <mike@fuhr.org>
0 siblings, 1 reply; 9+ messages in thread
From: Zouari Fourat @ 2005-03-31 10:06 UTC (permalink / raw)
To: Michael Fuhr <mike@fuhr.org>; +Cc: John DeSoi <desoi@pgedit.com>; pgsql-admin
anyone can help me with a sample of pg_hba.conf
On Wed, 30 Mar 2005 09:47:31 -0700, Michael Fuhr <mike@fuhr.org> wrote:
> On Wed, Mar 30, 2005 at 11:14:38AM -0500, John DeSoi wrote:
> > On Mar 30, 2005, at 10:17 AM, Zouari Fourat wrote:
> >
> > >is it really secure in a shared hosting environnement case ?
> > >do you advise me to offer pgsql in a shared hosting ?
> >
> > You can do all of the necessary things to control access to the
> > databases.
>
> ...like using pg_hba.conf to control who's allowed to connect to
> each database. If you don't want people to query the system catalogs
> for a particular database, then don't allow them to connect to that
> database (there are a few shared catalogs that anybody can query,
> however).
>
> The db_user_namespace configuration variable might help with managing
> access, but the documentation says that it's "intended as a temporary
> measure until a complete solution is found," so caveat administrator.
>
> --
> Michael Fuhr
> http://www.fuhr.org/~mfuhr/
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: problems with user rights
2005-03-28 13:32 problems with user rights Zouari Fourat <fourat@gmail.com>
2005-03-30 08:43 ` Re: problems with user rights Zouari Fourat <fourat@gmail.com>
2005-03-30 13:04 ` Re: problems with user rights John DeSoi <desoi@pgedit.com>
2005-03-30 15:17 ` Re: problems with user rights Zouari Fourat <fourat@gmail.com>
2005-03-30 16:14 ` Re: problems with user rights John DeSoi <desoi@pgedit.com>
2005-03-30 16:47 ` Re: problems with user rights Michael Fuhr <mike@fuhr.org>
2005-03-31 10:06 ` Re: problems with user rights Zouari Fourat <fourat@gmail.com>
@ 2005-03-31 17:59 ` Michael Fuhr <mike@fuhr.org>
0 siblings, 0 replies; 9+ messages in thread
From: Michael Fuhr @ 2005-03-31 17:59 UTC (permalink / raw)
To: Zouari Fourat <fourat@gmail.com>; +Cc: John DeSoi <desoi@pgedit.com>; pgsql-admin
On Thu, Mar 31, 2005 at 12:06:11PM +0200, Zouari Fourat wrote:
>
> anyone can help me with a sample of pg_hba.conf
See the "Client Authentication" chapter in the documentation. Here's
a link to the latest version (use a different link if you're using
an older version of PostgreSQL):
http://www.postgresql.org/docs/8.0/interactive/client-authentication.html
There are several examples at the bottom of the page.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2005-03-31 17:59 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-28 13:32 problems with user rights Zouari Fourat <fourat@gmail.com>
2005-03-30 08:43 ` Zouari Fourat <fourat@gmail.com>
2005-03-30 13:04 ` John DeSoi <desoi@pgedit.com>
2005-03-30 15:17 ` Zouari Fourat <fourat@gmail.com>
2005-03-30 16:14 ` John DeSoi <desoi@pgedit.com>
2005-03-30 16:43 ` Scott Marlowe <smarlowe@g2switchworks.com>
2005-03-30 16:47 ` Michael Fuhr <mike@fuhr.org>
2005-03-31 10:06 ` Zouari Fourat <fourat@gmail.com>
2005-03-31 17:59 ` Michael Fuhr <mike@fuhr.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox