sql server - Grant Select on a view not base table when base table is in a different database

Question

I have a view which is selecting rows from a table in a different database. I'd like to grant select access to the view, but not direct access to the base table. The view has a where clause restricting the number of rows.

Can I grant select to the view and not the base table, or do I need to switch to a stored procedure? I would rather not do it the latter way.

Answer 1

GRANT SELECT ON [viewname] TO [user]

should do it.