[GENERAL] Groups, permissions and visibility

2006-09-11 Thread jonathan . lister
Suppose I have two groups of users and want to keep some sensitive information "hidden" from one group as described in the simple example below. When connecting as user 'visitor' via pgAdmin I am surprised that I can easily browse the structure of tables and the code of functions owned by 't

Re: [GENERAL] Shared memory and FreeBSD's jail()

2005-05-19 Thread lister
Scott Marlowe wrote: On Thu, 2005-05-19 at 09:46, lister wrote: At the BSDCan tutorial last week on jails (and several other times) there was discussion regarding Postgres's use of system V style shared memory, and an unfortunate side effect of making jail() less secure. Specifically, to

[GENERAL] Shared memory and FreeBSD's jail()

2005-05-19 Thread lister
At the BSDCan tutorial last week on jails (and several other times) there was discussion regarding Postgres's use of system V style shared memory, and an unfortunate side effect of making jail() less secure. Specifically, to allow Postgres to operate in a jail()ed environment, the sysctl : jail.sys