Determining Role Access To Extender Objects


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.

Comments (1)

  1. David Musgrave says:

    Posting from Mark Polino at DynamicAccounting.net

    msdynamicsgp.blogspot.com/…/determining-role-access-to-extender.html