[Monetdb-developers] Triggers owner..

Fabian Groffen Fabian.Groffen at cwi.nl
Wed Nov 29 13:37:31 CET 2006


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.





More information about the developers-list mailing list