SQL Permissions Script


SELECT 'GRANT SELECT, INSERT, UPDATE, DELETE ON ' + name + ' To WebUser'
FROM dbo.sysobjects
WHERE xtype = 'U'
UNION
SELECT 'GRANT SELECT ON ' + name + ' To WebUser'
FROM dbo.sysobjects
WHERE xtype = 'V'
UNION
SELECT 'GRANT EXECUTE ON ' + name + ' To WebUser'
FROM dbo.sysobjects
WHERE xtype = 'FN' OR xtype = 'P'


U = Tables
V == View
P = Stored PRoc
TF = Function