Security

(0) Share

Report

Posted on by Community Member

I am working with a customer who has over 150 companies and more are added monthly. There are roughly 22 users and several are added weekly.

The security is no longer recognizing changes made on any comany. I ran the reconcile users- access as I had been instructed and that did absolutely no good.

My next step is to recreate the user security tables through the SQL maintenance however I am sure there was a knowledgebase article regarding this situation but I cannot find it anywhere.

if anyone has suggestions or can send me informaton on the KB article it would be greatly appreciated, as this is causing some significant concern and workarounds.

thanks very much

Carolyn

*This post is locked for comments

All responses (4)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

RE: Security

Hi Carolyn,

This is the main step you have to follow to trace the security for the certain user(s).

1) Take a backup of company & system database(s)

2) Click Microsoft Dynamics GP, point to Maintenance, and then click Clear Data to open the Clear Data window.

3) On the Display menu, click Physical.

4) In the Series list, click System.

5) In the Tables pane, click the Security Resource Descriptions table, and then click Insert.

6) Click OK.

In the Report Destination window, select the Screen check box, and then click OK to send the report to the screen.

Close the report.

The Security Resource Descriptions table is populated. You can use the table in an SQL query in Microsoft SQL Query Analyzer or in Microsoft SQL Server Management.

Please find the below query to trace the security & task for a certain window.

http://blogs.msdn.com/b/developingfordynamicsgp/archive/2008/11/12/how-to-identify-the-security-tasks-and-security-roles-associated-with-a-specific-window-or-report.aspx

to view the complete security details please refer the below link

http://victoriayudin.com/2009/03/20/sql-view-with-security-resource-details-for-dynamics-gp-10/

http://victoriayudin.com/2010/05/13/sql-view-with-security-and-smartlist-details-in-gp/

http://victoriayudin.com/2009/03/12/sql-view-to-show-security-roles-and-tasks-in-dynamics-gp-10/
MichaelC 1,763 on at

Like (0)

Report

RE: Security

Carolyn

Did Susan's answer solve this issue? Interested in how you resolved this situation.
Community Member on at

Like (0)

Report

RE: Security

Thank you Susan, I"ll try that on my most critical company and see what happens. If that works then off to the rest of the companies.

I appreciate your response very much!

Carolyn
sueconrod 337 on at

Like (0)

Report

RE: Security

Before you throw in the towel, did you do a checklinks on the security master Maintenance>>Checklinks.>>Company>>Security, then reconcile.

Here is the only article I can find on the security which also listed all the tables:

support.microsoft.com/.../951229

•SY09000: Task master

•SY09100: Role master

•SY09200: Alternate or modified form and report ID master

•SY09400: Security Resource Descriptions

•SY10000: User Security

•SY10500: Role assignment master

•SY10550: DEFAULTUSER task ID assignment master

•SY10600: Tasks assignments master

•SY10700: Operations assignments master

•SY10750: DEFAULTUSER task assignment

•SY10800: Alternate or modified form and report ID assignment master