Stored Procedure Question:
Download Questions PDF

State about the security aspects of stored procedures?

Answer:

Stored procedures should be written very carefully because they store complex and logical data. Security permissions should be very finely applied and this is possible by carefully written code. Permissions for client data should be set in such a manner that it could be accessible only by the client and the method of access should be according to the procedure laid down in the Stored procedures.

Download Stored Procedure Interview Questions And Answers PDF

Previous QuestionNext Question
State the different extensions for stored procedures?Does storing of data in stored procedures increase the access time? Explain?