May 12, 2010 at 7:30 am
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
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
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
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