[devmor]

I feel that if you have multiple sets of application logic that need to access the same data, there should be an internal API between them and the database that keeps that access to spec.

[mlfreeman]

Only allow clients to execute stored procedures?

[devmor]

That could certainly be one way to handle it, if your specific problem domain supports that logic being in stored procedures.