MySQL Forums
Forum List  »  Triggers

Re: Triggers now work (it's official)
Posted by: Markus Popp
Date: July 31, 2005 05:33PM

Hi,

that are some great things that are going on ;-). There's just one big question that I have about triggers - is it still up to date, that the SUPER privilege is required to let a user create triggers? Wouldn't that be a problem that it's impossible to give a non privileged user the permission to create triggers, without giving him also further unintended permissions (like e.g. killing processes)?

As for stored procedures (a little off topic here), I hope that in the final release it will be possible again to write self referencing SPs, use EXECUTE and PREPARE - and that it's possible to use variables in the LIMIT clause. These are very important features to make the language flexible.

For MySQL 5.1, I hope that SPs, UDFs and triggers also get extensive error handling features ;-).

Markus

--
Markus Popp, Web Developer, mysql.com
Oracle Austria

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Triggers now work (it's official)
2492
July 31, 2005 05:33PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.