Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
oyousef
Starting Member
2 Posts |
 Posted - 2009-12-02 : 07:15:51
|
| We have a table in the SQL database name Alies This table note of each period of the disappearance of all its contentsWe do not know what is the reason??!For your information the table is not deleted, but I think it is the work of Truncate TableAs is well known that this is his job to delete records in the tableIs there a way to protect this table and monitor changes that occur upon ???!!And prevent any person from the work to Truncate this table |
|
|
kbhere
Yak Posting Veteran
58 Posts |
Posted - 2009-12-02 : 07:26:45
|
| This will help you in restricting the truncation of your table.. If you have admin rights you can restrict permissions using GRANT..Kindly refer,http://doc.ddart.net/mssql/sql70/ga-gz_4.htmBalaji.K |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-12-02 : 07:28:23
|
| Revoke DELETE rights for all users except those who really do need it, then monitor those people to ensure they are not running a truncate. |
|
|
|
oyousef
Starting Member
2 Posts |
Posted - 2009-12-02 : 23:35:24
|
| Thank you all for help |
|
|
|
|
|
|
how to protect the table and watching for it