This chapter discusses administrative benefits of using stored routines and triggers. It covers the following exam topics:
Using stored routines and triggers for security purposes
Using stored routines to enhance performance
Stored routines provide security benefits for database administrators. You can define routines that safely access protected data on behalf of ordinary (non-administrative) users, but do not return information ...