[Monetdb-developers] Triggers owner..
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. Regards, Romulo
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.
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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
participants (2)
-
Fabian Groffen -
Romulo Goncalves