web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) The EXECUTE permission...

Microsoft Dynamics GP (Archived)

The EXECUTE permission was denied on the object 'zDP_EXT60100SS_1

(0) Share

Report

Report

Posted on by Carolina Hernandez

550

I created a new company, but after login it shows me the error I attach.
what should I do ?

Message Error:

Microsoft][SQL Native Client][SQL Server]The EXECUTE permission was denied on the object 'zDP_EXT60100SS_1', database 'PRUE2', schema 'dbo'.

Please your advice.

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Carolina Hernandez 550 on at

Like (0)

Report

RE: The EXECUTE permission was denied on the object 'zDP_EXT60100SS_1

Yes, thank for all.

Was this reply helpful? Yes No
Verified answer

Derek Albaugh on at

Like (1)

Report

RE: The EXECUTE permission was denied on the object 'zDP_EXT60100SS_1

Hello Carolina,

If you haven't already, run the Grant.sql script against the PRUE2 database.

This script gives the DYNGRP database role, which all GP users are assigned for the system and all company databases they have access.

The role gives users the SELECT, INSERT, DELETE, UPDATE permissions for GP tables and views, and EXECUTE permissions for stored procedures.

Let us know if this doesn't resolve the error.

Thanks,

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Our Community Code of Conduct has been updated!

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans