[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.

Only the owner of a table can create triggers on it.

More information about the developers-list mailing list