Membership.DeleteUser引发的诡异数据库错误,请指教,急

karldodd 2006-10-30 12:08:39
一直以来运转良好的系统。最近实现删除用户的功能。只是很简单地调用了Membership.DeleteUser而已,但报错如下。从错误上来看,是删除违反了外键冲突。但这些不都应该是.net 2.0用户管理框架的存储过程负责的么?怎么会有错?

有一点:在开发的机器上调试时无错,在部署后出的错。

Server Error in '/' Application.
--------------------------------------------------------------------------------

SELECT permission denied on object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.
SELECT permission denied on object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.
SELECT permission denied on object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.
SELECT permission denied on object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.
The DELETE statement conflicted with the REFERENCE constraint "FK__aspnet_Me__UserI__3493CFA7". The conflict occurred in database "CallCenter", table "dbo.aspnet_Membership", column 'UserId'.
The statement has been terminated.
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: SELECT permission denied on object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.
SELECT permission denied on object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.
SELECT permission denied on object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.
SELECT permission denied on object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.
The DELETE statement conflicted with the REFERENCE constraint "FK__aspnet_Me__UserI__3493CFA7". The conflict occurred in database "CallCenter", table "dbo.aspnet_Membership", column 'UserId'.
The statement has been terminated.

Source Error:

Line 38: string strUsername = Request["Username"];
Line 39: //MembershipUser member = Membership.GetUser(strUsername, false);
Line 40: Membership.DeleteUser(strUsername);
Line 41: Response.Redirect("ManageUsers.aspx");
Line 42: }


Source File: ***:\***\***\ViewUserDetail.aspx.cs Line: 40

Stack Trace:

[SqlException (0x80131904): SELECT permission denied on object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.
SELECT permission denied on object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.
SELECT permission denied on object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.
SELECT permission denied on object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.
The DELETE statement conflicted with the REFERENCE constraint "FK__aspnet_Me__UserI__3493CFA7". The conflict occurred in database "CallCenter", table "dbo.aspnet_Membership", column 'UserId'.
The statement has been terminated.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857434
……
……
...全文
98 2 打赏 收藏 转发到动态 举报
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
DePaul 2006-10-30
  • 打赏
  • 举报
回复
帮顶了,我这样用的没发生过这样的事情,呵呵
karldodd 2006-10-30
  • 打赏
  • 举报
回复
..自己顶一下

62,041

社区成员

发帖
与我相关
我的任务
社区描述
.NET技术交流专区
javascript云原生 企业社区
社区管理员
  • ASP.NET
  • .Net开发者社区
  • R小R
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告

.NET 社区是一个围绕开源 .NET 的开放、热情、创新、包容的技术社区。社区致力于为广大 .NET 爱好者提供一个良好的知识共享、协同互助的 .NET 技术交流环境。我们尊重不同意见,支持健康理性的辩论和互动,反对歧视和攻击。

希望和大家一起共同营造一个活跃、友好的社区氛围。

试试用AI创作助手写篇文章吧