Re: Different result set of view in different sessions: is it reliable?

Zoe wrote:
> Hello,
>
> I have a problem concerning views.
>
> Problem Definition: In an application, each application user should
> have access to specific departments. All application users connect to
> the database as scott; having a database user per actual application
> user is not an option due to specific limitations. The application
> already exists, and references dept.

Yes. It is not just reliable ... it is best practice.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)