[SQL] Permissions for foreign keys

2001-01-30 Thread Rick Delaney
If I don't want users to have UPDATE (or even SELECT) access on the other tables (bill and emp), but I want referential integrity, what can I do? -- Rick Delaney

Re: [SQL] Permissions for foreign keys

2001-01-31 Thread Rick Delaney
fixed in 7.0.3? And does fixed mean that NO permissions are required on the referencing or referenced tables, or are there still some restrictions? Also, where can I get the 7.1beta? I feel silly, but I can't seem to find it though postgresql.org. > > Rick Delaney wrote: > >

Re: [SQL] Permissions for foreign keys

2001-02-01 Thread Rick Delaney
Rick Delaney wrote: > > "Ross J. Reedstrom" wrote: > > > > This is a bug that was fixed in 7.1beta for sure, but also 7.0.3, > > I believe. So it's as simple as upgrading. > > Thanks, I'll upgrade. I couldn't find this listed in any chan