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 |
|
supersql
Yak Posting Veteran
99 Posts |
 Posted - 2005-10-07 : 14:39:11
|
| HIHow can I add userID for a report if there are more than 100 users who needs to view the report through their application.Does it make any sense if I am adding all the users to particular reports from the Reporting Manager of SQL Reprts.If the users to view report are going to increase day by day, then what? |
|
|
jhermiz
3564 Posts |
Posted - 2005-10-07 : 14:44:18
|
quote:
Originally posted by supersql
HIHow can I add userID for a report if there are more than 100 users who needs to view the report through their application.Does it make any sense if I am adding all the users to particular reports from the Reporting Manager of SQL Reprts.If the users to view report are going to increase day by day, then what?
RS uses domain users for a specific workgroup. As long as the user is part of the domain and has a valid user name and password then he / she can be part of this group. I am not sure what you mean by adding user id's. Create a group called "RS_Users" and add as many domain users as you would like to this group and give them read / execute permissions.jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
 |
|
|
supersql
Yak Posting Veteran
99 Posts |
Posted - 2005-10-07 : 15:42:40
|
| where do u want me to create a group, in the RM? |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-10-07 : 17:59:24
|
| No, create a group in your windows admin (Active Directory), add the users to the group, and then give the group permissions in Report Manager.---------------------------EmeraldCityDomains.com |
|
|
|
supersql
Yak Posting Veteran
99 Posts |
Posted - 2005-10-17 : 08:33:19
|
| So is tht the only way we can do like creating a group on windows and adding that group to my Report Manager. |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-10-17 : 09:02:08
|
quote:
Originally posted by supersql
So is tht the only way we can do like creating a group on windows and adding that group to my Report Manager.
I'm not certain exactly what kind of magical solution you want. I think Microsoft has done an excellent job taping into active directory and using domain security. Sure RS is not choke full of features, but look at something like Crystal reports where there interface has so much you don't know what to do with it. Plus they've integrated it into visual studio.net, I think they've done an excellent job.You can add seperate users to each report if you don't want to create groups, it's just more work on your end.Finally here is another solution, I'll provide the back end you provide the front end.Reports-------ReportIDUsers-------UserIDUserNameSecurity--------SecurityIDSecurityTypeUserReports-----------UserIDReportIDSecurityIDBut what you would have to do is create the interface to allow specific users to open up specific reports. For instance, your UserReport table could include multiple rows per one UserID for a specific report for a specific security feature.What you could do for your interface is allow the user to select the report from a list box or combo box, then check the security for that user and if that user has access allow he / she to open the report.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
|
|
|
|
|
Permissions