Membership.DeleteUser引发的诡异数据库错误,请指教,急
一直以来运转良好的系统。最近实现删除用户的功能。只是很简单地调用了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
……
……