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.
| Author |
Topic |
|
umaramiya
Starting Member
1 Post |
 Posted - 2007-07-24 : 00:58:04
|
| Hi,I am very new to SSRS. Currently I am developing a web project which involves report generation through SSRS. My SQL Server Database engine is configured to have Windows Authentication. I want my reports to be secure by creating Accounts. In such a case how can I create Accounts in SQL Report Server database set. Is it possible or is there any other approach to achieve this.Thanks,Uma Ramiya |
|
|
Maxer
Yak Posting Veteran
51 Posts |
Posted - 2007-07-30 : 11:27:18
|
| Can you elaborate on this.So what you mean is that Manager-Bob can see ManagementReport but Worker-Jim can not see that reprot?You can setup permissions in Reporting Services by connecting to it with the SSMS for reprot server or just going to the report server web page (provided you have admin or similar rights) and setting up user permissions.So you could create a folder called "Management" and all the reports in it would inherit that folder's permissions (if you so configure them).Then if Worker-Jim follows the URL (or just tries to navigate to the folder) he won't have access or even be able to see the folder if he is navigating inside the report server's web interface. (Or you could allow him to see it but not open it, etc...)You can also do filtering so that a report could return information about ALL the workers in a company. However, Worker-Jim can only see the data for his name, while management might be able to see all of it. |
 |
|
|
|
|
|
SQL Report Server Database Set