Groups | Blog | Home
all groups > sql server reporting services > july 2005 >

sql server reporting services : Local group permissions


Alex
7/13/2005 4:12:18 PM
Hi,

Is it possible to grant role assignment to report server local groups in
SSRS 2000? if so, how? I can't do it.

Thanks
Alex

Logicalman
7/13/2005 5:35:02 PM
I managed to set local group policy only by adding the users to a
server-level group and then assign that group permissions. The same can be
done by adding individual accounts to the server itself, but I was unable to
create groups within RS itself.

Hope this assists,

[quoted text, click to view]
Samson
7/14/2005 10:55:07 AM
Is is possible to restrict group rights per report using domain groups.

If I want a particular user to be able to view one or two reports and those
alone without viewing other reports, how would I attempt this. Say I want
only Sales see the sales reports, payroll to see only payroll, Tech Support
to see Tech Support and etc...

is this possible?


--
Regards,

Samson


[quoted text, click to view]
Logicalman
7/14/2005 5:54:01 PM
Samson,

Yes, you simply add the user to the group having permission on that report.
Be aware though, that by adding the user to that group he/she will then be
able to view ALL reports that particular group has permissions to.
example.
Report 1
Report 2
Report 3
Report 4

Group A
Group B

If Group A is given permission to browse Reports 1 and 2, and Group B is
given permission to view Reports 2,3 and 4.
By adding User X to Broup A, he/she will have access to Reports 1 and 2, by
adding User z to Group B he/she will have access to Reports 2,3 and 4.

If you want User Y to view Report 2 only, and no other Reports, then you
will need to either add that user directly to Report 2, or create a new Group
C, and assign permissions to Group C to view Report 2.
Again, such Gropus may be part of the Active Directory or the Server.

I hope this clears up any ambiguity.


[quoted text, click to view]
Samson
7/15/2005 4:21:03 PM
That is good news. I guess my question is how. I created 3 users groups,
sales, techs, payroll.

How do I set the permission on the particular folder that holds the reports?



--
Regards,

Samson


[quoted text, click to view]
Samson
7/19/2005 8:58:40 AM
I think after reading youtr post again I can set the permission within the
report as well. I think I understand now.


--
Regards,

Samson


[quoted text, click to view]
AddThis Social Bookmark Button