Developing for Dynamics GP

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

Analytical Accounting Security Tasks and Security Roles issue

Analytical Accounting Security Tasks and Security Roles issue

Rate This
  • Comments 3

David Meego - Click for blog homepageWhile working on a case recently with a colleague we noticed that a user received a security privileges error for some windows which were part of Analytical Accounting. 

We used the Support Debugging Tool's Security Information window to have a look at what was happening and found that there were Security Tasks and Security Roles set up for Analytical Accounting, but due to some data issues they were not working properly.

You can see the problems if you run the following queries in the DYNAMICS database:

select * from SY09100 where SECURITYROLEID like 'AA%'
select * from SY10600 where SECURITYROLEID like 'AA%'
select * from SY09000 where SECURITYTASKID like 'AA%'
select * from SY10700 where SECURITYTASKID like 'AA%'

Look closely at the returned data and you can see the SECURITYROLEID for AA CLERK* has an extra space before CLERK (two spaces rather than one) in the SY09100 table. Also the SECURITYTASKID for AADEFAULTUSER* has a space before the asterisk (*) in the SY10700 table.

To fix the data, run the following statements against the DYNAMICS database:

update SY09100 set SECURITYROLEID = 'AA CLERK*'
where SECURITYROLEID = 'AA  CLERK*'

update SY10700 set SECURITYTASKID = 'AADEFAULTUSER*'
where SECURITYTASKID = 'AADEFAULTUSER *'

This issue exists in GP 10 and GP 2010 and is currently scheduled to be fixed in GP 2010 Service Pack 3. 

Hope this is helpful.

David

Page 1 of 1 (3 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 7 and 1 and type the answer here:
  • Post