Ad Hoc Company Security

Is there a way in Ad Hoc reports to prevent users from querying data from another companies data? In my database each table row has a company Id so that my application only displays data for the currently logged in users company. Can I inforce this in ad hoc reporting?

Thanks,

Duncan

You could create a view that displays only the data for the company of the current user and then grant permission only to that view.

|||

The only problem with that is that you would need to create a different view for every company and have to set up a different model for each company. We have decided to leave out Ad-Hoc reporting for this version of our application and look at other alternatives later.

Duncan