这是不是SQL Server 没有 dbo 权限的问题?-领先建站CMS提供服务商我们专注于CMS建站产品的研发

1328 查看	1 回复

主题：[ICMS]这是不是SQL Server 没有 dbo 权限的问题? [收藏主题]

in_flight 当前离线

290 主题	2 广播	0 粉丝

级别:二年级

用户积分:1497 分
登录次数:128 次
注册时间:2008/6/28
最后登录:2018/9/3

in_flight 发表于：2015/6/18 15:51:29 | 只看该作者查看该作者主题楼主

一分钟快速开通线上知识店铺

Server Error in '/' Application.

拒绝了对对象 'KS_ProGetProFromCart' (数据库 'db_kesion'，架构 'dbo')的 EXECUTE 权限。 Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: 拒绝了对对象 'KS_ProGetProFromCart' (数据库 'db_kesion'，架构 'dbo')的 EXECUTE 权限。

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): 拒绝了对对象 'KS_ProGetProFromCart' (数据库 'db_kesion'，架构 'dbo')的 EXECUTE 权限。] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +1787814 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5341674 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +546 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +1693 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +61 System.Data.SqlClient.SqlDataReader.get_MetaData() +90 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +377 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) +1421 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +177 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +53 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +137 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +41 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +10 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +140 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +316 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +88 Kesion.DataBase.DBHelper.ExecuteDataset(DbConnection connection, CommandType commandType, String commandText, DbParameter[] commandParameters) +128 Kesion.DataBase.DBHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, DbParameter[] commandParameters) +84 Kesion.DataBase.DBHelper.ExecuteDataset(CommandType commandType, String commandText, DbParameter[] commandParameters) +26 Kesion.SqlDAL.ShopManage.GetProductFromShoppingCart(String userName) +176 Kesion.BLL.ShopManage.GetProductFromShoppingCart(String userName) +51 Kesion.APPCode.ShoppingCartUser.CheckShoppingCart() +103 Kesion.APPCode.ShoppingCart.initial() +6294 Kesion.NET.WebSite.Index.Page_Load(Object sender, EventArgs e) +5087 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +51 System.Web.UI.Control.OnLoad(EventArgs e) +92 System.Web.UI.Control.LoadRecursive() +54 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +772

这是不是SQL Server 没有 dbo 权限的问题?

南京茶叶网 http://www.025tea.com 茶叶网址：http://www.sochaw.cn

一分钟快速开通线上知识店铺