CODEWITHSUNDEEP
c#sql-server
Carlos Ferreira
Carlos Ferreira

Reputation: 159

How to disable access to an attached project database

We have a C# Winforms project with an attached database.

Working with .MDF database file using SQL Server Express LocalDB.

The application has some usage limits, for example, it has a maximum of records per module. Even if the user deletes some records, those records are flagged as deleted in the database but will never be really deleted in order to count all records (even deleted ones).

After distributing the application to the various users, we are concerned about database access with SSMS and tables/record violation.

Is it possible to prevent users from accessing the database so that users do not delete the records themselves, thus tampering with the accounting of records?

Thanks.

Upvotes: 0

Views: 97

Answers (1)

TomTom
TomTom

Reputation: 62157

Is it possible to prevent users from accessing the database so that users do not delete the records themselves, thus tampering with the accounting of records?

Nope. And it is not possible in ANY database technology. Which is why things like SAAS (Software As A Service) is a good choice for scenarios like this. At least you could send a "object created" signal and count that against the license.

Upvotes: 1

Related Questions