| From: | Michael Gill <mgill(at)pointdx(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Restrict access to system tables |
| Date: | 2003-12-17 15:30:16 |
| Message-ID: | 3FE07688.1010006@pointdx.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Please pardon the novice question, but I can't find my answer in my
books or the docs.
I want to keep as much data and table structure hidden from users as
possible. I have created a function to return data (using 'security
definer') and revoked all rights to a table for a user. This user can
now execute the function but not query the table directly... Great.
BUT this same user can use PgAdmin III or psql to view the "schema" --
everything except seeing the data.
Anyone have a suggestion as to how to limit a given user (a group
preferably) to only executing functions created by an administrator????
Thanks
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2003-12-17 15:45:43 | Re: Postgresql on software RAID |
| Previous Message | Ashok Chauhan | 2003-12-17 11:31:50 | system variable for update |