Company Deleted from Database

paulspiteri
paulspiteri Member Posts: 8
edited 2005-02-08 in NAV/Navision Classic Client
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

Comments

  • Sbhat
    Sbhat Member Posts: 301
    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
    g_dreyer Member Posts: 123
    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
    BGI Member Posts: 176
    Also have a look at the sql security, normaly a normal user should not be able to create or delete sql tables...
    Rgds
    Benny Giebens
  • facade
    facade Member Posts: 57
    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.

Categories