Encapsulation of tables with functions

From: "Nikola Milutinovic" <Nikola(dot)Milutinovic(at)ev(dot)co(dot)yu>
To: "PostgreSQL general" <pgsql-general(at)postgresql(dot)org>
Subject: Encapsulation of tables with functions
Date: 2002-01-14 12:13:32
Message-ID: 000701c19cf4$e28a1ce0$0a3ea8c0@ev.co.yu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all.

I guess you all know what encapsulation is in object oriented programming, so can it be done on PostgreSQL level?

To be precise, let's suppose:
- I have a TABLE "test", owned by user "app_owner"
- I have a FUNCTION "test_fn", owned by user "app_owner"
- This function accesses "test"
- I have another user "app_user"

Can I grant priviledges to "app_user" to execute "test_fn", but not to access "test"?

Nix.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Meskes 2002-01-14 12:37:06 Re: mysql-pgsql comparison
Previous Message Andy Samuel 2002-01-14 02:44:12 Re: again, LIKE operator