请问如何用ASP设置用户访问权限 - 编程论坛

我用ASP编写了一个用户登陆界面，用户的用户名和密码等登陆信息存放于一个Access数据库中，数据库与登陆页面连接正常，我现在只能设置成登陆后都进入同一个ASP页面，请问如何才能让不同的用户登陆后进入不同的页面呢？可否有相关代码？？
下面是我编写的用户登陆页面代码，请大家指正，谢谢！！

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>

<%
var Recordset1 = Server.CreateObject("ADODB.Recordset");
Recordset1.ActiveConnection = MM_user_STRING;
Recordset1.Source = "SELECT * FROM user";
Recordset1.CursorType = 0;
Recordset1.CursorLocation = 2;
Recordset1.LockType = 1;
Recordset1.Open();
var Recordset1_numRows = 0;
%>
<%
// *** Validate request to log in to this site.
var MM_LoginAction = Request.ServerVariables("URL");
if (Request.QueryString!="") MM_LoginAction += "?" + Server.HTMLEncode(Request.QueryString);
var MM_valUsername=String(Request.Form("name"));
if (MM_valUsername != "undefined") {
var MM_fldUserAuthorization="";
var MM_redirectLoginSuccess="logook/logook.asp";
var MM_redirectLoginFailed="logoError/logoError.htm";
var MM_flag="ADODB.Recordset";
var MM_rsUser = Server.CreateObject(MM_flag);
MM_rsUser.ActiveConnection = MM_user_STRING;
MM_rsUser.Source = "SELECT name, pass";
if (MM_fldUserAuthorization != "") MM_rsUser.Source += "," + MM_fldUserAuthorization;
MM_rsUser.Source += " FROM user WHERE name='" + MM_valUsername.replace(/'/g, "''") + "' AND pass='" + String(Request.Form("pass")).replace(/'/g, "''") + "'";
MM_rsUser.CursorType = 0;
MM_rsUser.CursorLocation = 2;
MM_rsUser.LockType = 3;
MM_rsUser.Open();
if (!MM_rsUser.EOF || !MM_rsUser.BOF) {
// username and password match - this is a valid user
Session("MM_Username") = MM_valUsername;
if (MM_fldUserAuthorization != "") {
Session("MM_UserAuthorization") = String(MM_rsUser.Fields.Item(MM_fldUserAuthorization).Value);
} else {
Session("MM_UserAuthorization") = "";
}
if (String(Request.QueryString("accessdenied")) != "undefined" && false) {
MM_redirectLoginSuccess = Request.QueryString("accessdenied");
}
MM_rsUser.Close();
Response.Redirect(MM_redirectLoginSuccess);
}
MM_rsUser.Close();
Response.Redirect(MM_redirectLoginFailed);
}
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<style type="text/css">

</style>
</head>

<body>
<div id="Layer1">
<form action="<%=MM_LoginAction%>" method="POST" name="form1" id="form1">
<p><input name="name" type="text" id="name" />
</p>
<p> <input name="pass" type="password" id="pass" />
</p>
<p align="center">
<input type="submit" name="Submit" value="登录系统" />
<input type="reset" name="Submit2" value="重新输入" />
</p>
</form>
</p>
</div>

[此贴子已经被作者于2006-8-22 22:47:02编辑过]