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

Answer 1

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.