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 |
|
Jsturgeon
Starting Member
3 Posts |
 Posted - 2011-04-06 : 12:02:31
|
| I have some reports that are for internal consumption only. Anyone in the company should be able to see them, however, the majority do not have access to the cubes. Can I set up the reports security so that no matter who clicks on the reports they can see them? How would I do this? Can I do this? |
|
|
HenryFulmer
Posting Yak Master
110 Posts |
Posted - 2011-04-13 : 18:23:57
|
| How are you populating your reports? You can set report security by using the Report Manager web interface after deploying your reports. |
 |
|
|
Jsturgeon
Starting Member
3 Posts |
Posted - 2011-04-14 : 09:05:29
|
| I am pulling the date from a sql table and then using the date as a parameter to pull the data from the cube. I am brand new at this and I am still trying to understand the security. So far I have not been able to figure out much. |
|
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2011-04-14 : 09:18:48
|
| You should be able to have Active Directory configured to allow wide open access. We use the Active Directory to also lock down report folders so that we can put supervisor level stuff in a spot where non-supervisory staff can't access it. Same for Director level and up. I think that by default any report that you put out there is accesible by all unless you specify permissions. So far you have told us that you are pulling from a SQL table. How are you "publishing" those results? Have you created a report file (rdl)? If so, have you pushed that file out to the reporting server? If so, have you configured DNS to give internal employees a link to click on to get to the report server?Hey, it compiles. |
|
|
|
Jsturgeon
Starting Member
3 Posts |
Posted - 2011-04-14 : 16:11:55
|
| If I understand your "publishing" question, I am doing Build, and then Deploy in BIDS. |
|
|
|
|
|
|
Can I allow anyone to view reports in SSRS 2008