Finance | Project Operations, Human Resources, ...

Clearing out old IDs

(0) Share

Report

Posted on by Richard Wheeler

75,730

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.

Categories:

Microsoft Dynamics GP

All responses (2)

Answers (0)

Richard Wheeler 75,730 on at

Like (0)

Report

RE: Clearing out old 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.
Suggested answer

Derek Albaugh on at

Like (0)

Report

RE: Clearing out old IDs

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