locked
Export to Excel - permission denied fn_EndOfThisFiscalYear RRS feed

  • Question

  • Hi All,

    We have a strange problem while normal user access CRM 2011 On-Premise edition (5.0.9690.2243).

    When an normal CRM User access views with option as "This fiscal year" (or anything related to Fiscal) they get an error "[Microsoft][ODBC SQL Server Driver][SQL Server]The EXECUTE permission was denied on the object 'fn_EndOfThisFiscalYear', database 'OrgName_MSCRM', schema 'dbo'.". This happen only when the filtering condition is set with any Fiscal dates option.

    Does anyone have any solution for this?

    Monday, November 26, 2012 2:17 PM

Answers

  • Hi,

    you will need to grant execute access at this object (function) to the user(s)

    grant it to specific user by executing this command on SQL as admin

    GRANT EXECUTE ON dbo.fn_EndOfThisFiscalYear TO [youruser]


    or grant it to everyone

    GRANT EXECUTE ON dbo.fn_EndOfThisFiscalYear TO PUBLIC

    in your case, the object name would be 

    hope it helps.

     


    cheers, S.Khan MCTS

    Tuesday, November 27, 2012 2:10 AM
  • The above post describes a solution, although it would be preferrable to grant the permission to the [Reporting Group {guid}] user.

    I expect the underlying cause is that a user would not normally require permission to the SQL functions, as they are accessed via the filtered views, and SQL ownership chains will grant permission in that case. However, here it seems like the function is reference directly as part of the query that CRM generates


    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Tuesday, November 27, 2012 9:52 AM
    Moderator

All replies

  • Hi,

    you will need to grant execute access at this object (function) to the user(s)

    grant it to specific user by executing this command on SQL as admin

    GRANT EXECUTE ON dbo.fn_EndOfThisFiscalYear TO [youruser]


    or grant it to everyone

    GRANT EXECUTE ON dbo.fn_EndOfThisFiscalYear TO PUBLIC

    in your case, the object name would be 

    hope it helps.

     


    cheers, S.Khan MCTS

    Tuesday, November 27, 2012 2:10 AM
  • The above post describes a solution, although it would be preferrable to grant the permission to the [Reporting Group {guid}] user.

    I expect the underlying cause is that a user would not normally require permission to the SQL functions, as they are accessed via the filtered views, and SQL ownership chains will grant permission in that case. However, here it seems like the function is reference directly as part of the query that CRM generates


    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Tuesday, November 27, 2012 9:52 AM
    Moderator
  • ajai,

    We are experiencing the same issue. Did you ever find a resolution to this issue?

    Thursday, December 3, 2015 4:45 PM