Home Forums SQL Server 2012 SQL 2012 - General Truncate permission only on specified tables RE: Truncate permission only on specified tables
SQListic
SSCertifiable
Points: 6904
More actions
July 19, 2013 at 11:38 am
#1634133
Thanks for your Input..
I got some input from my coleagues. This is what they suggested.
grant control on db0.personsto "SQLCentral\ptom"
It allowed to truncate that specified tables.. Does this has any security concerns ?