Sashidhar Kokku's blog

Browse by Tags

All Tags » SQL Server » Stored Procedures (RSS)
Sorry, but there are no more tags available to filter with.
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...