Company Deleted from Database

paulspiteri

Hi
We have a customer who has lost their company in the navision 3.70 (SQL) database twice now within the last week.

It looks like it's probably being performed by a malicious user but does anyone know if there are any weird bugs or other means by how this could happen?

Thanks
PaulSpiteri

Sbhat

There is no bug as far as i know in deleting company. Navision would always warn you if you are doing a company delete else the other option could be that there might be a code where you are deleting a company. Have a audit trail created when a user deletes a company, write the information into a log file, this way you could track the date and time and user who deleted the company.

Regards
SB.

g_dreyer

Or just take away the permissions to delete a company, might save you the trouble of restoring the company:

Role = "SUPER (DATA)"
Permission = "System", "1550", "File, Database, Delete"

So it must be a user with "SUPER", or "SUPER (DATA)" rights.
Be careful with giving users "SUPER" Role.

Regards,
gus

BGI

Also have a look at the sql security, normaly a normal user should not be able to create or delete sql tables...

facade

Put an error to company table OnDelete, but before the error write a code to log the user, date and time etc and save this log to a server location silently.