Navision 2013 delete users

If you want to delete all users on a Navision 2013 you have to run this in the SQL on the database that Navision is using:

truncate table [dbo].[access control]
truncate table [dbo].[user]
truncate table [dbo].[user property]
truncate table [dbo].[page data personalization]
truncate table [dbo].[user default style sheet]
truncate table [dbo].[user metadata]
truncate table [dbo].[user personalization]

Leave a Reply