March 2, 2011 at 3:43 am
Hi All,
could any body tel me how to give the truncate permission on table to the user in sql server 2008 r2?remember that that table doesn't referred by other table.
Thanks in advance.
March 7, 2011 at 8:30 am
either be in the dbo role or you need control permission.
The probability of survival is inversely proportional to the angle of arrival.
March 7, 2011 at 9:39 am
TRUNCATE TABLE: http://msdn.microsoft.com/en-us/library/ms177570%28v=SQL.100%29.aspx
From the permission section: The minimum permission required is ALTER on table_name. TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and are not transferable. However, 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.
I thought CONTROL would do it as well, and on my SS2K8 Dev instance, that seems to work.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply