Hello All,
I have developed a solution where the user can generate pivot based reports using excel with Analysis Services in the background.
Now the requirement is that the user should also be able to go offline.
I want to understand how can this be done. Given the fact that the data in the cube is of financial nature so we need to have very secure solution.
(I read about local cubes, but how will I secure them? today the customer is generating excel sheets and protects it with windows DRM.... the problem with that solution is that we have too much data to put in excel).
Securing local cubes:http://sqljunkies.com/WebLog/mosha/archive/2006/03/08/local_cube_password.aspx
|||
Passwords don't provide a good security solution because they can be shared, they are known to the person.
Let's say an employee who had the excel sheet is leaving the company, he takes it along to his new employer and uses it there because he has the password.
Is it possible to DRM (digital rights management) protect a local cube. So that everytime someone opens a cube it makes contact to the DRM server to decide what can be done and read/write to the cube?
As I said that our security requrirement is very critical because the cube contains a lot of financial data.
regards,
Abhishek.
|||There is no DRM integration with local cube files.
No comments:
Post a Comment