存储过程的执行权限被拒绝

本文介绍了存储过程的执行权限被拒绝的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我有具有存储过程的管理数据库.此存储过程基于提供的连接从不同的报告数据库中检索数据.为了向SP授予执行权限，我在SQL服务器级别创建了Login，并将Admin数据库映射到了它. 当我使用Windows应用程序执行存储过程时，它适用于报告数据库之一，而其他报告数据库却给出了执行权限被拒绝的错误. 你能建议如何处理吗? 在此先感谢， KD

Hi, I have Admin database which has a stored procedure. This stored procedure retrieves the data from different reporting databases based on the connection provided. For granting the execute rigths to SP, I have created the Login at SQL server level and mapped the Admin database to it. When I execute the stored procedure using Windows Application, it works for one of the reporting database whereas it gives execute permission denied error for other reporting database. Can you please suggest how to handle this? Thanks in Advance, KD

推荐答案

您是否授予了该帐户在另一个数据库上的权限?您必须对要在其上运行存储的proc的每个数据库执行此操作... Did you grant permission for the account on the other database? You have to do it for each database you want to run the stored proc on...

您能指导我如何授予数据库权限吗? 但是我很好奇，因为它适用于一个报告数据库，而不适用于其他报告数据库.同样，我也没有授予首先报告正在其上工作的数据库的权限. Can you please direct me on how to grant the permission for a database? But I am curious as it is working for a one reporting DB and not for other. Also I have not given permission to first reporting DB on which it is working on..