Question: Explain the security aspect of stored procedures

1. Stored procedures are not secure, because they can be executed from the command line as the root user
2. Stored procedures are secure, because the owner of the stored procedure can decide to whom access is granted
3. Stored procedures are secure, because applications can be given access to stored procedures and not any underlying variables
4. Stored procedures are not secure, because they can execute statements to drop tables or bulk delete data

Answer: The correct answer of the above question is Option C:Stored procedures are secure, because applications can be given access to stored procedures and not any underlying variables