Re: revoked permissions on table still allows users to see table's structure - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: revoked permissions on table still allows users to see table's structure
Date
Msg-id CAOR=d=1Zoo6K55wfkBpb_rx2Jb2ox_Lp5WBN1dGmYMLD3x=ADg@mail.gmail.com
Whole thread Raw
In response to revoked permissions on table still allows users to see table's structure  ("Juan Cuervo (Quality Telecom)" <juanrcuervo@quality-telecom.net>)
Responses Re: revoked permissions on table still allows users to see table's structure  ("Juan Cuervo (Quality Telecom)" <juanrcuervo@quality-telecom.net>)
Re: revoked permissions on table still allows users to see table's structure  ("Juan Cuervo (Quality Telecom)" <juanrcuervo@quality-telecom.net>)
List pgsql-admin
On Thu, Jul 21, 2011 at 6:08 PM, Juan Cuervo (Quality Telecom)
<juanrcuervo@quality-telecom.net> wrote:
> Hi All
>
> I'm new to the list, but have a few years as postgres user. I want to share
> what I consider a rare behavior of postgresql regarding database object's
> premissions:
>
> I have noticed that there is no way (at least no one I know) to prevent a
> user from seeing the table's structures in a database.
>
> Is this a normal behavior of the product ?

Yep.  Completely normal.

> Is there a way to prevent a user from seeing my table's, procedure's and
> function's code ?

Don't let them connect to the db?  That's all I can think of.

pgsql-admin by date:

Previous
From: "Juan Cuervo (Quality Telecom)"
Date:
Subject: revoked permissions on table still allows users to see table's structure
Next
From: Johann Spies
Date:
Subject: Re: Out of memory