pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHide structure
2+ messages / 2 participants
[nested] [flat]
* Hide structure
@ 2006-12-05 16:01 dev.department <dev.manager@spazio3d.net>
0 siblings, 1 reply; 2+ messages in thread
From: dev.department @ 2006-12-05 16:01 UTC (permalink / raw)
To: pgsql-admin
Dear Sirs,
We're a softwarehouse who is considering the possibility to insert the PostgreSQL 8.1 database in our software.
How can we prevent the visualization of structure and data (tables, views, etc.) of a PostgreSQL 8.1 database? Keep present that the person who has installed PostgreSQL 8.1 is the administrator of the PC in which it it installed, and so he could modify the configuration files of PostgreSQL 8.1 server (for example files as "pg_hba.conf", "postgresql.conf", ecc.).
We've also seen that command "pg_dump" allows to visualize all structures and data of a database simply knowing the user name and not his password...
Looking forward to your answer,
Best regards
Quagliotto Davide
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Hide structure
@ 2006-12-12 18:38 Scott Marlowe <smarlowe@g2switchworks.com>
parent: dev.department <dev.manager@spazio3d.net>
0 siblings, 0 replies; 2+ messages in thread
From: Scott Marlowe @ 2006-12-12 18:38 UTC (permalink / raw)
To: dev.department <dev.manager@spazio3d.net>; +Cc: pgsql-admin
On Tue, 2006-12-05 at 10:01, dev.department wrote:
>
>
>
> Dear Sirs,
>
> We're a softwarehouse who is considering the possibility to insert the
> PostgreSQL 8.1 database in our software.
> How can we prevent the visualization of structure and data (tables,
> views, etc.) of a PostgreSQL 8.1 database? Keep present that the
> person who has installed PostgreSQL 8.1 is the administrator of the
> PC in which it it installed, and so he could modify the configuration
> files of PostgreSQL 8.1 server (for example files as "pg_hba.conf",
> "postgresql.conf", ecc.).
>
> We've also seen that command "pg_dump" allows to visualize all
> structures and data of a database simply knowing the user name and
> not his password...
You can't. Even if postgresql tried to make it possible, it would be
wasted effort. anyone with any hacking knowledge could override it.
If you don't want people doing that, then host the database yourself, on
your own servers, and don't let the users directly log in.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-12-12 18:38 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-12-05 16:01 Hide structure dev.department <dev.manager@spazio3d.net>
2006-12-12 18:38 ` Scott Marlowe <smarlowe@g2switchworks.com>
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