Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

Security Task ID

Posted on by

I´m getting this message in GP with a new user:

"You don't have security privileges to this window. Contact your system administrator for assistance."

In the DEXSQL.log I found these lines... but I can't identify the window

{ CALL DYNAMICS.dbo.zDP_SY10000SS_1 ( 'carlosr2', 21, 949, 22112, 2 ) } 

{ CALL DYNAMICS.dbo.zDP_SY10000SS_1 ( 'carlosr2', 21, 0, 1808, 2 ) } 

{ CALL DYNAMICS.dbo.zDP_SY10000SS_1 ( 'carlosr2', 21, 0, 1813, 2 ) }

{ CALL DYNAMICS.dbo.zDP_SY10000SS_1 ( 'carlosr2', 21, 0, 1815, 2 ) } 

Please help...

Regards

Julia Gallegos

Categories:
  • RE: Security Task ID

    Thanks David, I sent this information to my client.

    Regards

    Julia

  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,837 Moderator on at
    RE: Security Task ID

    FYI: If you have GP Power Tools installed, it populates and maintains the Resources table with all the security resources.

    Such as Tables, posting permissions, document access, smartlists, navigation lists, etc.

    It also shows you what the security errors are and how to fix them without needing logs or SQL queries.

    Regards

    David

  • Suggested answer
    RE: Security Task ID

    The same blog I referenced has the steps to populate this table:

    Populate the Security Resource Description table to translate the Security ID value to a window name or to a report name. To do this, follow these steps:

    Log on to Microsoft Dynamics GP as the 'sa' when no other users are logged on.

    Click Microsoft Dynamics GP, point to Maintenance, and then click Clear Data.

    On the Display menu, click Physical.

    In the Series field, click System in the drop-down list.

    Click the Security Resources Description table, click Insert, and then click OK to process.

    Print the report to screen, and then check for errors.

    This will populate the SY09400 table with the following SECRESTYPE values:

    2: Forms /Windows

    23: Reports

    21: Service Procedures

    57: OData Stored Procedures (if Dynamics GP 2016 or later)

    58: OData Views (if Dynamics GP 2016 or later)

    Let us know if you have any questions.

    Thank you

  • RE: Security Task ID

    Hi Derek,

       In this case I have no data in SY09400 table, this procedure can't help me. Do you know why the table is empty?

    Regards

    Julia

  • Suggested answer
    RE: Security Task ID

    In addition to the GP Power Tools as an option, the following blog has the information needed to troubleshoot security errors in Dynamics GP similar to what you were seeing:

    https://community.dynamics.com/gp/b/dynamicsgp/posts/troubleshooting-security-permissions-error-messages-in-microsoft-dynamics-gp

    You had most of the information getting the zDP_SY10000SS_1 procedure calls from the dexsql.log, the SY09400 table, once populated, will help to correlate the information in those procedure calls.

    For example, this call:   { CALL DYNAMICS.dbo.zDP_SY10000SS_1 ( 'carlosr2', 21, 949, 22112, 2 ) } 

    From this, we see that the user id is 'carlosr2', the company id is 21, 949 represents Field Services, 2 means it is a window/form, and 22112 is the security id of the object.

    Using a populated SY09400 table, you can plug in this information using a script like this:

                select * from DYNAMICS..SY09400 where securityid = 22112 and dictid = 949 and secrestype = 2

    This script will show, under the DSPLNAME column, that the object in question is the 'Work Order Type Maintenance' window.

    Using the same steps, the other three calls are referencing the 'Employee Direct Deposit', 'Employee Profile' and 'W4-Employee's Withholding Certificate' windows, in order.

    Please let us know if you have any further questions.

    Thanks

  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,837 Moderator on at
    RE: Security Task ID

    Hi Julia

    You should look at using GP Power Tools to solve your security issues. Using the Security Profiler you can identify the exact window and the Security Information window will help you fix the issue.

    Try the free 30 day trial period, just install and follow on screen instructions.

    GPPT Portal: http:/WinthropDC.com/GPPT

    Using the log information with the Information Resource window to identify the windows:

    949, 221122 = SVC_Depot_Type_Maintenance (Work Order Type Maintenance)

    0, 1808 = ddESSDepositEntry (Employee Direct Deposit)

    0, 1813 = uprESSEmployeeProfile (Employee Profile)

    0, 1815 = uprESSW4Withholding (W4 - Employee's Withholding Certificate)

    Regards

    David

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,570 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,683 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans