Post reply

Permisison to Truncate table

  • May 12, 2010 at 7:30 am

    #386912

    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.

  • May 13, 2010 at 3:50 am

    #1166739

    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;-)

  • May 13, 2010 at 4:08 am

    #1166746

    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.

  • May 13, 2010 at 4:13 am

    #1166748

    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