Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Axel Erwin Figueroa]

Hi!

Is there a way to restore all security setup to their default state as in a clean installation? Apparently a “Power User” changed some Tasks and now we have some unexpected problems with Sales and RM users while posting.

Is this possible?

Thanks!

——————————
Axel Erwin Figueroa
Pan American Grain Mfg
Guaynabo
——————————

[Darin Vialpando]

Axel,
 I have attached a link to Mariano Gomez resetting GP security- to provide you with instruction on what needs to be done to “revert” to default. 

resetting security roles

Thanks,
Darin

——————————
Darin Vialpando
IT Business Applications Manager
Kroenke Sports & Entertainment
Denver CO
——————————
——————————————-

[Axel Erwin Figueroa]

Great!

Thanks a lot!

Regards,

Erwin

——————————
Axel Erwin Figueroa
Pan American Grain Mfg
Guaynabo
——————————
——————————————-

[Derek Albaugh]

Along with Mariano’s blog, if you had/have a backup of the DYNAMICS system database from before the changes to the default security roles/tasks was done, you could also restore a copy NOT on top of the current DYNAMICS database but as something like ‘OLDDYNAMICS’ on the same SQL instance and DTS security information over from the following tables:

SY09000
SY09100
SY09200
SY10500
SY10550
SY10600
SY10700
SY10800

If changes were just made to security tasks, then the SY10700 table would be really the only one you would need to reset, as the SY10600 would be the one that holds the security role information.

SY10500 is a list of what security roles assigned to each user in each company database and the SY10800 tables are the alternate/modified forms and reports security tables.

Just FYI…………..

Thanks

——————————
Derek Albaugh
Sr. Support Engineer
Microsoft
Moorhead MN
——————————
——————————————-