I like this idea quite a bit. No application server means less maintenance and less administrative overhead.

Of course, it also means that the newly-empowered database has to scale out just as easily as an application server. For starters, request authentication becomes the responsibility of the database, and that could mean heavy volume.