| From: | Michael Gill <mgill(at)pointdx(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Restrict users from describing table |
| Date: | 2003-12-30 09:53:27 |
| Message-ID: | 3FF14B17.509@pointdx.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hello,
I've tried asking this question elsewhere and have not received a
satisfactory response.
I want to restrict users of my packaged database from directly accessing
the data or reading the schema. I would provide access to the read-only
data through functions (which works well in PG). I find that \d will
expose the structure even though the user can't select:
movies=> \d codeset.first_table
Table "codeset.first_table"
Column | Type | Modifiers
--------+---------+-----------
col1 | integer |
col2 | integer |
movies=> select * from codeset.first_table;
ERROR: permission denied for schema codeset
Is there any way to hide the structure from a particular user. I can't
use Postgresql if I can't encapsulate our intellectual property.
Thanks,
Michael Gill
mgill(at)pointdx(dot)com
mydba(at)usa(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | strk | 2003-12-30 10:30:30 | sticky sequence |
| Previous Message | Teodor Sigaev | 2003-12-30 09:40:03 | Concurrence GiST |