When a user creates a stored program that accesses sensitive

Question

When a user creates a stored program that accesses sensitive data but forgets that other people who can invoke the object have the same access, the security context is __________ A. good B. bad C. illegal D. fare The question was asked in an internship interview. Asked question is from Security for Stored Programs and Views in division Stored Programs of MySQL

fahmy · Accepted Answer

The correct answer is B. bad Best explanation: The security context is bad if a user creates a stored program that accesses sensitive data but forgets that other people who can invoke the object have the same access to that data as its definer.