[RDBO] Database Permissions when inserting (relationships).

2008-01-09 Thread Curon Davies
The attaches file contains some code that I've put together which reflects a situation that I have come across in our system, which has different database permissions for different users, with users not being granted more permissions than needed for their task. The file works fine if the User (in

Re: [RDBO] Database Permissions when inserting (relationships).

2008-01-09 Thread John Siracusa
On Jan 9, 2008 2:05 PM, Curon Davies <[EMAIL PROTECTED]> wrote: > The file works fine if the User (in this case 'rose_test') has DELETE > permission the on 'price' table, but fails otherwise. From my > prospective this should definitely not be the case, as the only action > performed here is insert