• 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 ?