Monday, March 26, 2012

rsAccessDenied even for the Content Manager role

I have the Content Manager rights on a folder and on a report for my user.
When I try to edit ther report properties I got the error
the permissions granted to user `domain\user` are insufficient for
performing this operation (rsAccessDenied)
I am able to upload, create folders, create data source, upload file, but
not to view the report properties
--
AlexSounds like someone changed the Security for that Particular report, so you
can't mess with it...
All of the things you can do, have perms at the folder level...Report
properties can be set at the report level, so if someone removed
ContentManager Role from the specific report, you'd get the behaviour you are
seeing..
Hope this helps.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
See you at the PASS Conference!
"Alex" wrote:
> I have the Content Manager rights on a folder and on a report for my user.
> When I try to edit ther report properties I got the error
> the permissions granted to user `domain\user` are insufficient for
> performing this operation (rsAccessDenied)
> I am able to upload, create folders, create data source, upload file, but
> not to view the report properties
> --
> Alex|||I just verified it and It has the Content Manager perms
I even created a new folder with the builtin\Administrators Content
Manager and the Server\user Content Manager too.
I checked the report's security tab, and in all the reports in that folder I
have both, the Builtin\Administrators Content Manager and the Server\user
Content Manager permissions.
But Still having the rsAccessDenied Error
I would appreciate very much any help about it
Thanks
--
Alex
"Wayne Snyder" wrote:
> Sounds like someone changed the Security for that Particular report, so you
> can't mess with it...
> All of the things you can do, have perms at the folder level...Report
> properties can be set at the report level, so if someone removed
> ContentManager Role from the specific report, you'd get the behaviour you are
> seeing..
> Hope this helps.
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
> See you at the PASS Conference!
>
> "Alex" wrote:
> > I have the Content Manager rights on a folder and on a report for my user.
> >
> > When I try to edit ther report properties I got the error
> > the permissions granted to user `domain\user` are insufficient for
> > performing this operation (rsAccessDenied)
> >
> > I am able to upload, create folders, create data source, upload file, but
> > not to view the report properties
> >
> > --
> > Alex|||I had the same problem you described and fixed it by granting the NT group
the 'Content Manager' permissions at the 'Root' of the Report Server site.
After doing this the permissions were applied correctly to the Folders
underneath this.
Hope this helps.
Diran
"Alex" wrote:
> I just verified it and It has the Content Manager perms
> I even created a new folder with the builtin\Administrators Content
> Manager and the Server\user Content Manager too.
> I checked the report's security tab, and in all the reports in that folder I
> have both, the Builtin\Administrators Content Manager and the Server\user
> Content Manager permissions.
> But Still having the rsAccessDenied Error
> I would appreciate very much any help about it
> Thanks
> --
> Alex
>
> "Wayne Snyder" wrote:
> > Sounds like someone changed the Security for that Particular report, so you
> > can't mess with it...
> >
> > All of the things you can do, have perms at the folder level...Report
> > properties can be set at the report level, so if someone removed
> > ContentManager Role from the specific report, you'd get the behaviour you are
> > seeing..
> >
> > Hope this helps.
> > --
> > Wayne Snyder MCDBA, SQL Server MVP
> > Mariner, Charlotte, NC
> >
> > I support the Professional Association for SQL Server ( PASS) and it''s
> > community of SQL Professionals.
> > See you at the PASS Conference!
> >
> >
> > "Alex" wrote:
> >
> > > I have the Content Manager rights on a folder and on a report for my user.
> > >
> > > When I try to edit ther report properties I got the error
> > > the permissions granted to user `domain\user` are insufficient for
> > > performing this operation (rsAccessDenied)
> > >
> > > I am able to upload, create folders, create data source, upload file, but
> > > not to view the report properties
> > >
> > > --
> > > Alex|||Thanks Diran,
It worked, I just granted the "My Reports" permissions.
Thanks again!
--
Alex
"Diran" wrote:
> I had the same problem you described and fixed it by granting the NT group
> the 'Content Manager' permissions at the 'Root' of the Report Server site.
> After doing this the permissions were applied correctly to the Folders
> underneath this.
> Hope this helps.
> Diran
>
> "Alex" wrote:
> > I just verified it and It has the Content Manager perms
> >
> > I even created a new folder with the builtin\Administrators Content
> > Manager and the Server\user Content Manager too.
> >
> > I checked the report's security tab, and in all the reports in that folder I
> > have both, the Builtin\Administrators Content Manager and the Server\user
> > Content Manager permissions.
> >
> > But Still having the rsAccessDenied Error
> >
> > I would appreciate very much any help about it
> > Thanks
> >
> > --
> > Alex
> >
> >
> > "Wayne Snyder" wrote:
> >
> > > Sounds like someone changed the Security for that Particular report, so you
> > > can't mess with it...
> > >
> > > All of the things you can do, have perms at the folder level...Report
> > > properties can be set at the report level, so if someone removed
> > > ContentManager Role from the specific report, you'd get the behaviour you are
> > > seeing..
> > >
> > > Hope this helps.
> > > --
> > > Wayne Snyder MCDBA, SQL Server MVP
> > > Mariner, Charlotte, NC
> > >
> > > I support the Professional Association for SQL Server ( PASS) and it''s
> > > community of SQL Professionals.
> > > See you at the PASS Conference!
> > >
> > >
> > > "Alex" wrote:
> > >
> > > > I have the Content Manager rights on a folder and on a report for my user.
> > > >
> > > > When I try to edit ther report properties I got the error
> > > > the permissions granted to user `domain\user` are insufficient for
> > > > performing this operation (rsAccessDenied)
> > > >
> > > > I am able to upload, create folders, create data source, upload file, but
> > > > not to view the report properties
> > > >
> > > > --
> > > > Alex

No comments:

Post a Comment