Home Forums Reporting Services SSRS 2014 SSRS Report Security - RE: SSRS Report Security -

  • August 1, 2017 at 9:44 am

    #1953616

    lnpurdie - Tuesday, August 1, 2017 9:34 AM

    Well I cannot check - the DBAs will have to.  I was surprises as the SAME Data Source used by the other data sets which would be accessing the same schema - using procedures.   The obvious was permissions, yes.  Thought maybe somehow the SQL Text vs Procedure was part of the problem but I suspect its is as obvious as it appears.  The DBA(s) maybe only have granted Exec on report procedures - and not granted SELECT on dbo.   Its an inherited solution from 2009.  I'll shift it upstream and not waste my time on it.

    Thanks guys.  Sometimes the obvious is the best answer

    Provided that the owner of the objects is the same and the objects are in the same database, then the permissions would be inherited. If, however, this is not the case, then permission will need to be granted on not only the SP, but any objects which have different owners, or are in a different database. I would suggest that this is the case here.

    Note, cross database ownership does exist, but comes with its own security risks, so is often not switched on, and is not enabled by default.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk