Developing for Dynamics GP

by David Musgrave (Perth, WA, Australia) and the Microsoft Dynamics GP Developer Support Team (Fargo, ND, USA)

Determining Role Access To Extender Objects

Determining Role Access To Extender Objects

  • Comments 1

Patrick Roth - Click for blog homepageAn Extender case came up recently where the customer was having security issues with Extender forms.

To solve the issue, we needed to determine which Security Roles have access to particular Extender forms.

Note: This method uses the DYNAMICS.dbo.EXT00001 table which was added for version 10.0 Service Pack 4 and later.

We were able to resolve the issue by running a few SQL queries that were consolidated into one query as shown below.  I was able to, ahem, leverage David Musgrave's SQL Security script here to get started.

SQL Query

To check access, set the EXT.CMPANYID to the Company ID that you want to check access for.  Change the EXT.Extender_ID to the ID of the Extender object.

Result Set

The results above show that the only role that can access to this Extender form named "BRACKET" is the AR CLERK* role in the selected company.  Any user in the POWERUSER role would also have access to the form as well.

Hope this helps out,

Patrick Roth
Microsoft Dynamics GP Developer Support

23-Nov-2010: Add note about compatible versions.

Page 1 of 1 (1 items)
Comments Information

PLEASE READ BEFORE POSTING

Please only post comments relating to the topic of this page.

If you wish to ask a technical question, please use the links in the links section (scroll down, on right hand side) to ask on the Newsgroups or Forums. If you ask on the Newsgroups or Forums, others in the community can respond and the answers are available for everyone in the future.

Leave a Comment
  • Please add 6 and 6 and type the answer here:
  • Post