Posts Tagged ‘Truncate Table permission to specific user’

Let in your environment there are lots of SQL user and as a DBA you have to give permission to a specific user to truncate table only. The specified User have no select/delete/insert/update permission on table.

In this scenario we have to grant ALTER permission to that user.

USE [VirendraTest] — VirendraTest is here database Name
GO

GRANTĀ ALTERĀ ON [dbo].[TestTable] TO [Virendra] — Virendra is a User
GO