Finance | Project Operations, Human Resources, ...

Security Task ID

(0) Share

Report

Posted on by Julia_Gallegos

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:

Microsoft Dynamics GP

All responses (6)

Answers (0)

Julia_Gallegos on at

Like (0)

Report

RE: Security Task ID

Thanks David, I sent this information to my client.

Regards

Julia
Suggested answer

David Musgrave MVP ... 13,945 Most Valuable Professional on at

Like (0)

Report

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

Derek Albaugh on at

Like (0)

Report

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
Julia_Gallegos on at

Like (0)

Report

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

Derek Albaugh on at

Like (1)

Report

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 ... 13,945 Most Valuable Professional on at

Like (0)

Report

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