RE: [GENERAL] permissions & foreign keys

2000-09-04 Thread Tamsin
That's cleared that up, thanks! Tamsin -Original Message- From: Jan Wieck [mailto:[EMAIL PROTECTED]] Sent: 04 September 2000 15:50 To: Tamsin Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] permissions & foreign keys Tamsin wrote: > > I don't really see wh

Re: [GENERAL] permissions & foreign keys

2000-09-04 Thread Jan Wieck
Tamsin wrote: > > I don't really see why it wants to update feedback_type? Can anyone tell me > what I'm doing wrong, or will I just have to grant update on feedback_type > (and all other tables referenced by FKs)? > It doesn't want to update it. It just does the SELECT ... FOR UPDATE to

[GENERAL] permissions & foreign keys

2000-09-04 Thread Tamsin
Hi, I am having some problems setting up security on my database: I have a table 'feedback', with a foriegn key to a table 'feedback_type' (tables at end). I want to give the user all permissions on feedback, but to only be able to select the possible values from the feedback_type table. So, I