Explain the security aspects of stored procedures

Question

Explain the security aspects of stored procedures.

Answer 1

Stored procedures must be written very carefully since they store complex and logical data. Security permissions must be very lastly applied and it is possible by carefully written code. Permissions for client data must be set in a certain manner that this could be accessible only by the client and the way of access must be according to the procedure laid down within the stored procedures.