Re: Oracle Discoverer v3.0 - Security

On 8 Jul 1998 13:39:07 GMT, "Iain Airlie" <ima84531_at_GlaxoWellcome.co.uk> wrote:

>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
>>
>>
Thanks for that Ian....

Problem is that we are not just talking of 2 users, our system will have at least 2000 users, many of whom will have restricted access to sub-sets of the Employee data.

In effect what we need is the equivalent of associating a 'where' clause to the query so that only rows designated as allowable for that particular user are visible.

Regards

Huw. Received on Wed Jul 08 1998 - 16:31:55 CEST