Disable / Remove Advanced Security

[ale1981]

I have enabled Advanced Security in GP 7.5 to see what it was like, i now want to disable it and remove anything it has created, how would i do this?

 

[winthropdc]

I am not sure I would agree with you disabling Advanced Security as once you have let the accelerator build, it will provide you with a much more powerful and flexible interface into security. But then again, I designed and developed Advanced Security.

FYI: The performance for v8.0 is significantly better as it was re-written to use more SQL optimisation.

Have a look at the Advanced Security FAQ for more information:

https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;894705

To disable Advanced Security (make it believe it has not been used), you need to delete the records from the accelerator table.

In the Dynamics (System) database

delete from DYNAMICS.dbo.WDC51100
delete from DYNAMICS.dbo.WDC51101
delete from DYNAMICS.dbo.WDC51102

If using an external Accelerator, find the location of the tables and delete the following files:

WDC51100.DAT & WDC51100.IDX
WDC51101.DAT & WDC51101.IDX
WDC51102.DAT & WDC51102.IDX

David Musgrave [MSFT]
Original Developer of Advanced Security
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)

http://www.microsoft.com/Dynamics

mailtoavid.Musgrave@online.microsoft.com

http://blogs.msdn.com/DevelopingForDynamicsGP

Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[winthropdc]

PS: if the tables mentioned do not exist for your version, don't worry some tables were added in later builds and I looked at v8.0 to check the tables.

 

[ale1981]

Hi David,

Thanks for your reply. As you say, Advanced Security is much better than the standard security but at the moment in v7.5 it is to slow to use. We are upgrading to v10.0 in a couple of months and will take a look at it again then.

I will delete from those tables and let you know.

Many Thanks

 

[ale1981]

Thanks that worked;

delete from DYNAMICS.dbo.WDC51100
delete from DYNAMICS.dbo.WDC51101
delete from DYNAMICS.dbo.WDC51102 (this table doesnt exist in GP 7.5)

 

[winthropdc]

FYI: Advanced Security does not exist in v10.00 as the entire Security system has changed.

David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)

http://www.microsoft.com/Dynamics

mailtoavid.Musgrave@online.microsoft.com

http://blogs.msdn.com/DevelopingForDynamicsGP

Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[tania1234]

We have been using Advanced Security 8.0 for 3 years and the accelerator is too large...
would we use any functionality if we just 'reset accelerator' and keep it turned on (synchronized at all times)?

 

[winthropdc]

You can change the Accelerator settings to not use background processing.

Then reset the accelerator to clear the contents.

Then the accelerator would only cache the records needed in the foreground on demand. It means that the first time you look at a new user, it would need to cache in the foreground as the data would not have already been created by the background process.

Once the cache records for the users you are working with have been created it will not need to cache them again. So it is only going to be slower the first time for each user.

This will reduce the size of the accelerator as it will not contain records for every user/company and class combination.

David Musgrave [MSFT]
Original Developer of Advanced Security
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)

http://www.microsoft.com/Dynamics

mailtoavid.Musgrave@online.microsoft.com

http://blogs.msdn.com/DevelopingForDynamicsGP

Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.