From: tshad on 3 Jun 2010 17:13
If you give a user datareader and datawriter, does that also give the user
execute permissions on the stored procedures, views and user functions?
From: Erland Sommarskog on 4 Jun 2010 03:13
tshad (t(a)dslextreme.com) writes:
> If you give a user datareader and datawriter, does that also give the user
> execute permissions on the stored procedures, views and user functions?
You get SELECT permissions on views and functions; you cannot have EXEC
rights on views, nor on table-valued functions.
To give users EXECUTE rights in general, you can say:
GRANT EXECUTE ON SCHEMA::dbo TO user
GRANT EXECUTE TO user
to grant EXEC rights in all schemas.
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se
Books Online for SQL Server 2005 at
Books Online for SQL Server 2000 at