Re: Oracle Discoverer v3.0 - Security

[Quoted] Create a view on employee addresses that only returns those of interest.

As long as the view has all mandatory columns employee A will be able to perform all functions that could be carried out in the underlying table.

Huw.Price_at_gecm.com wrote in article
<35a35611.15534805_at_news.geccs.gecm.com>...
> Problem.
> Is there any way that I can implement user-based security within
> discoverer? We have the following scenario,
>
> User A and user B both had access to a Business area of 'Personnel
> Information' and access to the folder 'Employee addresses' which is a
> view off all employee addresses on the system.
>
> What we require in the 'real world' is that when user 'A' retrieves
> employee addresses, the query only ONLY brings back the employees
> relative to his department, not the whole organization
>
>
Received on Wed Jul 08 1998 - 15:39:07 CEST