Grant permission to only a view

Question

I have one user in my database, and I want to grant to him permission to read only one view, nothing more, no tables, nothing.

How can I do this?

Thanks a lot.

P.S.: I am using MS SQL Server 2005

Solution 1

USE DB1;
GRANT SELECT ON OBJECT:: View1 TO JohnDoe;
GO

Refer to GRANT Object Permissions for other examples of granting permission

Solution 2

Try this:

GRANT SELECT ON whatever_your_view_is_called TO bob_or_whatever_his_name_is