Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

Clearing out old IDs

Posted on by 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:
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    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
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans