Analytical Accounting Security Tasks and Security Roles issue


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

Comments (3)

  1. Interesting… Glad to know about this issue… 🙂

  2. David Musgrave says:

    Posting from Jivtesh Singh at About Dynamics, Development and Life

    http://www.jivtesh.com/…/everything-dynamics-gp-27.html

  3. David Musgrave says:

    Posting from Mark Polino at DynamicAccounting.net

    msdynamicsgp.blogspot.com/…/analytical-accounting-security-tasks.html