Prev: ssms 2005 temp table issue
Next: Remote restore
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?

Thanks,

Tom


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

or simply

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
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
 | 
Pages: 1
Prev: ssms 2005 temp table issue
Next: Remote restore