对象“xxxxxxx"、数据库“zzzzzzz"、架构“dbo"的 EXECUTE 权限被拒绝 [英] The EXECUTE permission was denied on the object 'xxxxxxx', database 'zzzzzzz', schema 'dbo'

问题描述

我在执行函数时遇到问题.

这是我所做的:

1. 使用 SQL Server Management Studio 创建函数.已成功创建.
2. 然后我尝试执行新创建的函数，结果如下:

<块引用>

EXECUTE 权限被拒绝对象xxxxxxx"，数据库'zzzzzzz'，架构 'dbo'.

解决方案

听起来您需要为相关存储过程授予用户(或他们所属的组)执行权限.

例如，您可以授予访问权限:

使用 zzzzzzz;将 dbo.xxxxxxx 上的 EXEC 授予公共

I'm having problems executing a function.

Here's what I did:

1. Create a function using SQL Server Management Studio. It was successfully created.
2. I then tried executing the newly created function and here's what I get:

The EXECUTE permission was denied on the object 'xxxxxxx', database 'zzzzzzz', schema 'dbo'.

解决方案

Sounds like you need to grant the execute permission to the user (or a group that they a part of) for the stored procedure in question.

For example, you could grant access thus:

USE zzzzzzz;
GRANT EXEC ON dbo.xxxxxxx TO PUBLIC

这篇关于对象“xxxxxxx"、数据库“zzzzzzz"、架构“dbo"的 EXECUTE 权限被拒绝的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！