[Monetdb-developers] Triggers owner..
R.A.Goncalves at cwi.nl
Wed Nov 29 13:30:46 CET 2006
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
(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.
More information about the developers-list