Using Oracle's Application Context we have an intermediate level between traditional sql security model and the programmatic solution.

This model provides high level of security because is controled by the database.

Its faster than the programmatic approach, it runs into the server memory space.

Its easy to maintain, the code is packaged into an unique and centralized database schema, any change to the security logic will be made into this schema.

As a drawback, this model is quite flexible than the programmatic approach. Not all the security models could be implemented.

next section Application Context