高分求基于b/s应用系统的用户权限管理方案及实现步骤。 高分求基于b/s应用系统的用户权限管理方案及实现步骤。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 http://www.aspxboy.com/Files/71/66/255.Aspxhttp://blog.csdn.net/onlytiancai/archive/2004/08/18/78116.aspxhttp://msdn.microsoft.com/library/chs/default.asp?url=/library/CHS/cpguide/html/cpconASPNETAuthentication.asp CREATE TABLE [dbo].[Operation_D] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [groupID] [int] NULL , [opt_MasterID] [int] NULL , [opt_DetialID] [int] NULL , [opt_Detial] [int] NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[PopedomD] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [MasterID] [int] NOT NULL , [DetialTitle] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[PopedomM] ( [MasterID] [int] IDENTITY (1, 1) NOT NULL , [title] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[group] ( [grp_id] [int] IDENTITY (1, 1) NOT NULL , [grp_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [grp_info] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[operation_M] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [group_ID] [int] NULL , [opt_masterID] [int] NULL , [opt_master] [bit] NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[user_group] ( [ug_id] [int] IDENTITY (1, 1) NOT NULL , [ug_user] [int] NULL , [ug_group] [int] NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[users] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [UserID] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [user_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [user_grade] [smallint] NULL ) ON [PRIMARY]GOSET QUOTED_IDENTIFIER ON GOSET ANSI_NULLS ON GOCREATE VIEW dbo.user_operationASSELECT dbo.users.user_name, dbo.operation_M.opt_masterID, dbo.operation_M.opt_masterFROM dbo.user_group INNER JOIN dbo.users ON dbo.user_group.ug_id = dbo.users.ID RIGHT OUTER JOIN dbo.operation_M INNER JOIN dbo.[group] ON dbo.operation_M.group_ID = dbo.[group].grp_id ON dbo.user_group.ug_group = dbo.[group].grp_idGOSET QUOTED_IDENTIFIER OFF GOSET ANSI_NULLS ON GOSET QUOTED_IDENTIFIER ON GOSET ANSI_NULLS ON GOCREATE VIEW dbo.user_operation_DASSELECT dbo.users.user_name, dbo.Operation_D.opt_DetialID, dbo.Operation_D.opt_DetialFROM dbo.Operation_D INNER JOIN dbo.[group] ON dbo.Operation_D.groupID = dbo.[group].grp_id LEFT OUTER JOIN dbo.user_group INNER JOIN dbo.users ON dbo.user_group.ug_id = dbo.users.ID ON dbo.[group].grp_id = dbo.user_group.ug_groupGOSET QUOTED_IDENTIFIER OFF GOSET ANSI_NULLS ON GO 100 求高手推荐好用灵活ASP.NET的CMS .NET中实现在线看视频 有没有控件能把计算的临时数据显示出来,并把选定的数据写入数据库? 为什么我的Login空间不能居中呢?在IE8中 在VS2010中将公司项目映射到本机上,但是映射下来后缺少bin文件 求聊天室和在线视频网站的思路. .net程序里如何检测用户有没有安装视频插件或者耳机? 有做过程序与outlook联系人互导的吗? 谢谢大家 .net 不允许操作POST的数据吗? 怎么实现把HTML控件中的信息添加到数据库 求一权限管理的解决方案!200分(不够再加)!! 请问大家在做项目的时候是否要加上版权信息?
http://blog.csdn.net/onlytiancai/archive/2004/08/18/78116.aspx
http://msdn.microsoft.com/library/chs/default.asp?url=/library/CHS/cpguide/html/cpconASPNETAuthentication.asp
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[groupID] [int] NULL ,
[opt_MasterID] [int] NULL ,
[opt_DetialID] [int] NULL ,
[opt_Detial] [int] NULL
) ON [PRIMARY]
GOCREATE TABLE [dbo].[PopedomD] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[MasterID] [int] NOT NULL ,
[DetialTitle] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GOCREATE TABLE [dbo].[PopedomM] (
[MasterID] [int] IDENTITY (1, 1) NOT NULL ,
[title] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GOCREATE TABLE [dbo].[group] (
[grp_id] [int] IDENTITY (1, 1) NOT NULL ,
[grp_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[grp_info] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GOCREATE TABLE [dbo].[operation_M] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[group_ID] [int] NULL ,
[opt_masterID] [int] NULL ,
[opt_master] [bit] NULL
) ON [PRIMARY]
GOCREATE TABLE [dbo].[user_group] (
[ug_id] [int] IDENTITY (1, 1) NOT NULL ,
[ug_user] [int] NULL ,
[ug_group] [int] NULL
) ON [PRIMARY]
GOCREATE TABLE [dbo].[users] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[UserID] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[user_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[user_grade] [smallint] NULL
) ON [PRIMARY]
GOSET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GOCREATE VIEW dbo.user_operation
AS
SELECT dbo.users.user_name, dbo.operation_M.opt_masterID,
dbo.operation_M.opt_master
FROM dbo.user_group INNER JOIN
dbo.users ON dbo.user_group.ug_id = dbo.users.ID RIGHT OUTER JOIN
dbo.operation_M INNER JOIN
dbo.[group] ON dbo.operation_M.group_ID = dbo.[group].grp_id ON
dbo.user_group.ug_group = dbo.[group].grp_idGO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GOSET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GOCREATE VIEW dbo.user_operation_D
AS
SELECT dbo.users.user_name, dbo.Operation_D.opt_DetialID,
dbo.Operation_D.opt_Detial
FROM dbo.Operation_D INNER JOIN
dbo.[group] ON dbo.Operation_D.groupID = dbo.[group].grp_id LEFT OUTER JOIN
dbo.user_group INNER JOIN
dbo.users ON dbo.user_group.ug_id = dbo.users.ID ON
dbo.[group].grp_id = dbo.user_group.ug_groupGO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO