Permisison to Truncate table

  • Hi,

    I want to grant a specific permission for a user to truncate table without any other permisions (create, alter etc.).

    (Not DDL_ADMIN too)

    Is there any permission for that?

    Thanks,

    Ran.

  • i dont think a non sys admin can truncate any table

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • Hi,

    Even though you require alter permission to truncate a table, the article in the link below has a 'workaround' where you

    you can incorporate the TRUNCATE TABLE statement within a module, such as a stored procedure, and grant appropriate permissions to the module using the EXECUTE AS clause

    http://msdn.microsoft.com/en-us/library/ms177570.aspx

    Hope that helps!

    Jinx.

  • Thank you!!! nice work around!!!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply