SQL存储过程的问题 [英] Issue with SQL Stored procedure

问题描述

我可以在ULS日志中看到以下条目

I could see the below entries in the ULS log

02/08/2010 14:36:46.12 w3wp.exe(0x15F4)0x18A0 CMS发布8x0a高AppDomainUnloadListener.RegisterSelf()输入了锁定(this = 15368010)

02/08/2010 14:36:46.12 w3wp.exe (0x15F4) 0x18A0 CMS Publishing 8x0a High AppDomainUnloadListener.RegisterSelf() entered lock(this=15368010)

02/08/2010 14:37:25.59 w3wp.exe(0x15F4)0x1744 Windows SharePoint Services数据库880i高System.Data.SqlClient.SqlException:找不到存储过程'dbo.proc_GetDatabaseInformation'.

02/08/2010 14:37:25.59 w3wp.exe (0x15F4) 0x1744 Windows SharePoint Services Database 880i High System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.proc_GetDatabaseInformation'.

02/08/2010 14:37:32.53 w3wp.exe(0x15F4)0x1744 Windows SharePoint Services数据库98rs高尝试向用户"X"授予对SQL Server上"Y"数据库的访问权限时发生错误.如果调用者没有在sql服务器中执行此操作的权限，或者数据库是只读的，则可能会出现这种情况.为确保SharePoint正常运行，请在执行此操作之前手动授予该用户对数据库的访问权限.还必须授予用户访问数据库中db_owner组的权限.错误提供了以下信息:用户没有执行此操作的权限.

02/08/2010 14:37:32.53 w3wp.exe (0x15F4) 0x1744 Windows SharePoint Services Database 98rs High An error occured while trying to grant the user "X" access to the "Y" database on the SQL server. This may be expected if the caller does not have permission to perform this operation in sql server or if the database is read-only. To ensure that SharePoint functions correctly, manually grant this user access to the database before performing this operation. The user must also be granted access to the db_owner group in the database. The following information was provided with this error: User does not have permission to perform this action.

02/08/2010 14:37:32.53 w3wp.exe(0x15F4)0x1744 Windows SharePoint Services数据库880i High System.Data.SqlClient.SqlException:用户没有执行此操作的权限.

02/08/2010 14:37:32.53 w3wp.exe (0x15F4) 0x1744 Windows SharePoint Services Database 880i High System.Data.SqlClient.SqlException: User does not have permission to perform this action.

有任何线索吗?

推荐答案

无论什么数据库用户调用此存储过程，都将需要具有该存储过程的执行权限，或者需要具有一般的执行权限.您的客户端程序可能对应一个或多个数据库用户.

Whatever database user is calling this stored procedure will either need to have execute permissions for the stored procedure specifically or execute permissions in general. Your client program probably corresponds to one or more database users.

GRANT EXECUTE ON dbo.proc_GetDatabaseInformation TO [DatabaseUserName]

这篇关于SQL存储过程的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！