Stored Procedure - belli user lara execute yetkisi vermek
Definition Description
--Bu sp yi her kullaninin truncate yetkisi olmadigindan,bu yetkiyi sadece DBA kullanabileceginden dolayi yazdım.Bu sayede gerekli tablolari truncate edilebilecek. USE [KariyerMainDB] GO /****** Object: StoredProcedure [dbo].[up_TruncateTable] Script Date: 09/20/2012 15:05:34 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE procedure [dbo].[up_TruncateTable] @table VARCHAR(100) with execute as owner as begin --set @table = 'hede' declare @string varchar(1000) set @string = 'TRUNCATE TABLE '+@table --exec (@string) print (@string) end GO
