Deletion of BCM Account

[Brenden Ward]

Does anyone know if there is a way of changing permissions in the SQL server
database to stop users deleting an account or contact.
Maybe there is a stored proceedure that runs when a user tries to delete
which we can place a deny against a particular user or group so when they try
to delete an item it will not allow this to happen.
We are using BCM database to pull in data into a infopath form so it is
important that the data doesn't remove itself from the database.
Any help will be really appreciated.
Brenden Ward
(e-mail address removed)

 

[Luther]

Does anyone know if there is a way of changing permissions in the SQL server
database to stop users deleting an account or contact.
Maybe there is a stored proceedure that runs when a user tries to delete
which we can place a deny against a particular user or group so when theytry
to delete an item it will not allow this to happen.
We are using BCM database to pull in data into a infopath form so it is
important that the data doesn't remove itself from the database.
Any help will be really appreciated.
Brenden Ward
(e-mail address removed)

When shared users "delete" an Account, they only move it to the
deleted items folder. All the data is still in the database. Only the
database owner can delete Accounts in the deleted items folder, and
actually remove the data from the database.