Announcements
When you go to Tools->Setup->System->Alternate/Modified Forms and Report the very first field is called ID. For our clients who had GP prior to the security model changing to roles, for every user there is an ID called CNV_name along with DEFAULTUSER. Is it safe to simply remove all of these? Is there a script to help speed up this process? Some clients have upwards of a hundred IDs.
Thanks Derek, those were some of the tables I found when I did a search. I have been staring at these ID's for over 10 years now. It is time for them to go. These are tables I found.
SELECT * FROM DYNAMICS..SY09000 WHERE SECURITYTASKID LIKE 'CNV%'
SELECT * FROM DYNAMICS..SY09100 WHERE SECURITYROLEID LIKE 'CNV%'
SELECT * FROM DYNAMICS..SY09200 WHERE SECMODALTID LIKE 'CNV%'
SELECT * FROM DYNAMICS..SY10600 WHERE SECURITYROLEID LIKE 'CNV%'
SELECT * FROM DYNAMICS..SY10700 WHERE SECURITYTASKID LIKE 'CNV%'
SELECT * FROM DYNAMICS..SY10800 WHERE SECMODALTID LIKE'CNV%'
I did not find anything the DYNAMICS..SY10550 table.
Back when Dynamics GP converted from the old 'Advanced Security' model to the current security role and task model, the security permissions assigned to users at that time were converted into 'custom' security roles and tasks that begin with CNV and then will have the name of the user and the name of the company for which it is for, as you mentioned.
I imagine for each user there is also a CNV / DEFAULTUSER as well for the permissions to modified/alternative forms and reports they had at that point as well.
If you don't need them any longer, similar to a custom security role or security task, you should be able to remove them, though I don't know of any script we have to do this in mass and we would always recommend that any changes are done within the GP application itself over through SQL directly.
The tables that should have this information are SY09000, SY09200, SY10550, SY10800. As always, make sure backups of the GP databases are done before any removal is done.
Thanks
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156