Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Export to Excel - permission denied fn_EndOfThisFiscalYear RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    3
    Sign in to vote

    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
  • Question
    Sign in to vote
    1
    Sign in to vote

    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

  • Question
    Sign in to vote
    3
    Sign in to vote

    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
  • Question
    Sign in to vote
    1
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    ajai,

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

    Thursday, December 3, 2015 4:45 PM