Stored Procedure Question:
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.
| Previous Question | Next Question |
| State the different extensions for stored procedures? | Does storing of data in stored procedures increase the access time? Explain? |