SP Grant Execute

246 views Asked by At

I have a new role, which should have permission to execute list of SP and select some Views. I run grant execute/select to role on <object>. Do I need to grant this role select permission to the table used in SP/Views taking in hand that those tables are located in different schemes?

Owner of all schemes/SP/Views across DB is dbo.

1

There are 1 answers

0
laggerok19 On

Don't understand why it that "-1", maybe because that person is silly, but anyway the answer is: No.

Explanation: We don't need to grant select to any object if owner of the object and SP/View is the same.