Generate a Script to Grant Permissions on all items to WebUser group
[CODE] 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' [/CODE] U = Tables V == View P = Stored PRoc TF = Function
