ibrahim A
asked on
securing Excel files with ADRMS
Hi All,
I have SQL 2008 Database, I will be using ms excel 2007 or 2010 to access the sql analysis services using excel Data tab, I want to use RMS to keep some security in theses files ex, prevent printing, etc, what is the best way to publish the excel file and keeping the security that I need.
my target: user will access sql database using excel but no printing, etc.
please advise
I have SQL 2008 Database, I will be using ms excel 2007 or 2010 to access the sql analysis services using excel Data tab, I want to use RMS to keep some security in theses files ex, prevent printing, etc, what is the best way to publish the excel file and keeping the security that I need.
my target: user will access sql database using excel but no printing, etc.
please advise
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
RMS should do it to my knowledge. Note that it's not included in standard CALS. You need additional licensing.
//Marten
//Marten
ASKER
I do have the license, i need to know what is the best solution to protect the excel connectivity to sql server
Many different users, a share with rights for a AD group
Just for yourself, EFS encrypted folder
To prevent many users from printing it:
ADRMS, it wont stop users from using a cellphone camera, but still, they will be aware that they are breaking the rules.
Other questions, or is this to your satisfaction?
Just for yourself, EFS encrypted folder
To prevent many users from printing it:
ADRMS, it wont stop users from using a cellphone camera, but still, they will be aware that they are breaking the rules.
Other questions, or is this to your satisfaction?
ASKER