Righteous violence. One of the benefits of stored procedures they don't mention is SECURITY DEFINER, which is like setuid. You can for instance have a user ta

Righteous violence. One of the benefits of stored procedures they don't mention is SECURITY DEFINER, which is like setuid. You can for instance have a user table with login and hashed password, have a stored procedure that can verify login and password, without giving SELECT access to the user table to the database user your application use. Stored procedures also block SQL injection attacks.