FGAC Question

[bayflash27]

We have a reporting system in discoverer where we allow a Buying company's manager to view only his own company's report or allow a Super user to view all reports.

i need to add another condition, i.e. a Supplier company's manager should also be allowed to view his own company's reports.

A supplier may have many buyers and vice versa.

I'm unable to create a system context for the Supplier company's manager, is there a way I can do this in Discoverer ? and not in the database ?

Thanks.

[TimHall]

Hi.

I'm no discoverer expert, but contexts and FGAC are a DB thing, so I think you are going to have to get your hand dirty I'm afraid. These might help:

http://www.oracle-base.com/articles/...bases(VPD).php
http://www.oracle-base.com/articles/...nAccessControl
http://www.oracle-base.com/articles/...nts10g.php#vpd

Cheers

Tim...