grant - exec view permissions

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

Execute permission doesn't apply to views. Do you mean you tried granting select permission on the view?

Greg

Steve Jones - SSC Editor SSC Guru Points: 736455 More actions · Answer 2

That's correct, Exec applies to functions and stored procedures.

SELECT applies to tables and views.

curious_sqldba SSC-Dedicated Points: 36494 More actions · Answer 3

SSC-Dedicated

Points: 36494

November 25, 2008 at 5:08 pm

thanks...