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

2008-01-10 Thread Curon Davies
Hi John. Thanks for your help on this. Unfortunately that still doesn't quite work. If we do: $product = My::DB::Product->new(name => $^T); $product->add_prices( { price => 3.60, region => 'uk' }, { price => 7.00, region => 'us' }, ); and then: my @prices = $product->prices;

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

2008-01-10 Thread Curon Davies
On Jan 9, 2008 20:02, John Siracusa <[EMAIL PROTECTED]> wrote: > In the meantime, you can always express more explicitly the operations > you intend to perform. For example: > > $product = My::DB::Product->new( > name => $^T, > add_prices => > [ > { price => 3.60, region => 'uk' }, >

[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