Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Item Level Permissions Expand / Collapse
Author
Message
Posted Monday, March 18, 2013 11:55 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, January 17, 2014 11:31 AM
Points: 26, Visits: 180
Hello -

I have a question about granting/denying item-level permissions within Reporting Services. Here's an example of what I need to do. I need to create 2 folders for departmental reports. Each department should only have access to their own report folder and associated reports. Each department will have admin users who will create and publish reports to the appropriate report folder. The tricky part is... I would like to grant access for those admin users to create, modify, and publish, but not delete. I do not what the admin users to delete or overwrite the report.

I think I have the majority of permissions figured out but I do not know how to handle the item-level permissions such as "delete". I am okay with the user deleting a report if I can track it. So if a user comes to me and says "someone deleted my report"... I want to be able to audit this action.

I would appreciate any advice/help!

Mike

Post #1432290
Posted Wednesday, April 17, 2013 8:06 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, January 17, 2014 11:31 AM
Points: 26, Visits: 180
So it doesn't look like the permissions are this granular. I basically told the end-users to be careful when managing reports. At least I can lock down permissions by folder and handle it that way.

Thanks!

Mike
Post #1443278
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse