为什么权限会这么奇怪？

Question

一个用户在数据库中时db_reader和db_writer的权限，一个存储过程中是对一个表的update操作。

为什么这个用户不能执行这个存储过程呢？

 

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 1

Does user have exec permission on that sp?

Answer 2

Does user have exec permission on that sp?

没有，难道必须要显式的赋权吗？

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 3

Can't run sp without exec permission on it, unless user has dbo rights or is creator of the sp.

Answer 4

Can't run sp without exec permission on it, unless user has dbo rights or is creator of the sp.

Yeah.The user is the creator of the sp.

but when exec it,it shows that there is no permission to run it.

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 5

The sp owned by that use? Need exec permission if not.

Answer 6

The sp owned by that use? Need exec permission if not.

是的。本来最开始的时候只是datareader和datawriter的权限，但是后来不知道什么时候加了一个ddladmin的权限，所以可以创建SP。 当时他们可以使用账号创建SP，里面仅仅是操作数据的权限，但是一执行这个SP的时候 就报错了。。。提示没权限

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 7

是不是有显式的deny exec权限？

---

想不想时已是想，不如不想都不想。

Answer 8

是不是有显式的deny exec权限？

---

想不想时已是想，不如不想都不想。

 

没有。。。我很确定。。。。

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 9

Grant exec permission then try again.