• truncate is not granular like that; it's inherent in db_owner and db_ddladmin, i believe.

    just make sure noone has those rights.

    what difference is there if the user is allowed to delete all rows vs truncate for you?

    don't you want to prevent data deletion in general and not just the truncate command?

    you could add an object with schema binding, like a view, on any table and that would prevent truncation at all., but not deleting.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!