Skip to Content
0
Former Member
Apr 09, 2010 at 09:44 AM

Controlling data access at universe level

497 Views

Hi,

I had a doubt in universe regarding the implementation of security.

Existing process: We had a portal called flex (intranet site)which the BO report has been integrated and for opening the report the name of report was clicked (hyperlink)

This report should show the data specific to the user profile logged into the portal.

Now if we want to restrict the data at universe level for each individual users accessing the report in portal our idea is to create a dervied table (which contains a list of userid's and project id's)in universe so that who ever logged into the portal and clicks on report he will see the data only related to profile

For example: The scenario would be a manager residing in a region need to see the list of projects which he is assigned to but not all of them.

Could you please let me know how can implement at universe. Kindly let me know if you need any futher information.

Thanks,

Eswar