January 31, 2008 at 11:47 am
Does anyone know exactly what "System User" rights in SQL 2005 Reporting Services does? It appears to be required for someone to be able to use the Report Builder, to even see the icon. I am just concerned about what else it might give them the rights to do.
January 31, 2008 at 12:15 pm
According to Brian Larson in 'Microsoft SQL Server 2005 Reporting Services':
the system user role has the ability to 1) Execute report definitions 2) View report server properties and 3) veiw shared schedules.
This is one of two 'system wide security task roles' the other being the system administrator role which basically gives you access to everything on the report server.
System user role looks pretty safe from here.
January 31, 2008 at 12:23 pm
I want the user to be able to run reports on "HIS" data, but don't want the user to be able to run reports on the whole SQL DB, just the DB's that he has access to.
January 31, 2008 at 12:42 pm
you should be able to accomplish that easily with database and table permissions using enterprise manager. only grant the user database and select permission on the tables he needs access to. Reporting services can't override that setting.
January 31, 2008 at 12:50 pm
Ok, we are using global groups to control which DB they can access, we just want to make sure that the System User rights don't go too far, over ride what we setup.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply