how to hide database objects from users, that don't have access to them

From: Oleksandr Pryymak <public(at)inmind(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: how to hide database objects from users, that don't have access to them
Date: 2007-02-15 21:38:24
Message-ID: 45D4D2D0.4010703@inmind.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Actually we've got a problem developing a DB with a lot of logic in it:
Our database has couple different interfaces to other systems (made
using views and procedures) and some interfaces need to be public or
semi-public. Even if we grant all rights correctly, each user, that able
to connect to the DB, has rights to view structures of all it components
(procedures/views/tables..) even he has no kind of access rights to them (!)

We've been little in trouble about, as far we can't open structure
and especial plenty a lot of logic inside in procedures (mainly written
in pgsql) to all users, as far we can't trust them.

If there any workaround to fix this and provide different users
interfaces to DB showing only objects, they have access to?

really would be grateful for help, as far we notice this hidden
trouble to late to change project design.

---
Sincerely yours,
Oleksandr Pryymak

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Emi Lu 2007-02-15 21:46:31 Re: postgresql 8.2 Installation error at "gmake"
Previous Message Guido Neitzer 2007-02-15 21:29:27 Re: Database performance comparison paper.