Sashidhar Kokku's blog

Browse by Tags

All Tags » Stored Procedures (RSS)
Granting EXEC permissions to stored procedures (SQL Server)
Granting execute permissions to all stored procedures in your database. 1: DECLARE @T TABLE (RowID INT Identity ( 1,1 ), Permission varchar (200)) 2:   3: INSERT @T(Permission) 4: SELECT CASE ISNULL(DATA_TYPE, '' ) WHEN 'TABLE' THEN ' grant select...
Posted: Dec 06 2007, 02:10 PM by Sashidhar Kokku | with 9 comment(s)
Filed under: ,