[Monetdb-developers] Triggers owner..

Romulo Goncalves R.A.Goncalves at cwi.nl
Wed Nov 29 14:04:17 CET 2006


Fabian Groffen wrote:
> On 29-11-2006 13:30:46 +0100, Romulo Goncalves wrote:
>> Dear developers,
>>
>> I am using SQL cvs head and M5.
>>
>> If I create a table and a new user with a mclient:
>>
>> create user "user_test" with password 'pass' NAME 'test1_user' SCHEMA "sys";
>>
>> create table t1 (id int);
>>
>> If then I connect with the new user and I create a trigger on t1:
>>
>> create trigger test1 after insert on t1
>>          insert into t1 values(12);
>>
>>
>> I do not get any error.
>> Well, depending on the approach followed in MonetDB it can be a bug or not.
>> (1) If we decide that a trigger over a table can only be created by the 
>> table owner (in this case the monetdb user is the owner of t1) this is a 
>> bug.
>> (2) If any user is allowed to create a trigger over any table, this is 
>> not a bug.
>>
>> What approach is followed by MonetDB?
>> If any which one we should choose?
>> In my opinion we should choose the first approach.
> 
> +1
> Only the owner of a table can create triggers on it.
> 
So, I will report as a bug. ;)

Regards,
Romulo
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Monetdb-developers mailing list
> Monetdb-developers at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-developers





More information about the developers-list mailing list