| From: | "Horst Herb" <hherb(at)malleenet(dot)net(dot)au> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org>, "Ruslan P(dot) Yawdoshak" <ra(at)boy(dot)univ(dot)kiev(dot)ua> |
| Subject: | Re: Question ! |
| Date: | 2000-10-10 08:31:29 |
| Message-ID: | 015701c03294$7dbc1280$e7d2fea9@esmith.midgard |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> Hove i can restrict access for tables in postgeSQL
> and users can anly call function to change tables entries ?
> (In function I'll self control access)
Give all users but one fictive "superuser" read-only access. Write a tier using pqlib as only means to get write access to the data base (this tier connects as the fictive "superuser" to the backend). Implement your functions in that tier.
However, you probably don't want to do that. What you really might want is just writing "before insert or update" triggers implementing your functions. That way, no write access will happen before the triggered function has processed the data. Am I wrong?
Horst
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Mount | 2000-10-10 10:26:46 | Re: Re: JDBC Performance |
| Previous Message | Peter Keller | 2000-10-10 08:19:22 | index on points |