I need to deny access to a user to a local replica .The user no longer working in the company.
are There some methods to do, when the user replicate the database??
thanks in advanced
Subject: The way to deny local access to an already terminated employee
… is with a court order. I assume you already have added the user to your Terminated group, so they will not be able to access the server. So nothing you do on the server will affect their already-existing local replica.
If users have copies of information on computers not owned by the company (or which the company failed to get returned to them when the employee left), there’s a limit to what you can do about it technologically.
If you have an opportunity to prepare in advance, you might be able to do something in the design of the application before they’re terminated to delete the local replica, which might catch the user by surprise the first time they run across it. But if they keep backups, they can access the data in those without using the UI.
Or you can prevent them creating a local replica in the first place by disabling that access.
If the data in all local replicas are encrypted, then they should be unable to access it once their certificate expires. But there’s nothing to prevent them creating copies of data in unencrypted form.
In fact, this is a general problem with all digital data. If the user has access to it at one time, there’s always some way for them to create a private copy that they can use indefinitely.