Re: [GENERAL] question/problem concerning GRANT/REVOKE

2008-04-30 Thread Scott Marlowe
On Tue, Apr 29, 2008 at 2:46 AM, Gerhard Wohlgenannt <[EMAIL PROTECTED]> wrote: > hi! > > I have a pretty basic problem: We have several schemas in one of our > databases, and we need the users to see only the tables (and table > structure) of tables inside their own schema. So I created schemas

[GENERAL] question/problem concerning GRANT/REVOKE

2008-04-29 Thread Gerhard Wohlgenannt
hi! I have a pretty basic problem: We have several schemas in one of our databases, and we need the users to see only the tables (and table structure) of tables inside their own schema. So I created schemas for those users, and set their "search_path". But with \d public. users can see all