Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 trace users

Author  Topic 

Oliver wang
Yak Posting Veteran

50 Posts

Posted - 2010-12-08 : 02:24:35
hi everybody,

I have a question here. Now we have a datacube, 2 dimentions(columns) are sensitive data and we want to trace users who have seen them from backgroud. One possible way to achieve that is running a profiler on the databcube(database), and record all the activities. But that will affect the proformance since too much activities will be recorded. I'm wondering whether there is a better tools to do this or whether we can narrow down the monitoring scope to a specific table or even columns. Your effort will be appreciated.

regards,

Oliver
   

- Advertisement -