Click here to Skip to main content
15,891,136 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: the opposite of Page_Validate Pin
GenJerDan23-Feb-11 4:46
GenJerDan23-Feb-11 4:46 
GeneralRe: the opposite of Page_Validate [modified] Pin
Not Active23-Feb-11 6:34
mentorNot Active23-Feb-11 6:34 
GeneralRe: the opposite of Page_Validate Pin
Ali Al Omairi(Abu AlHassan)23-Feb-11 10:41
professionalAli Al Omairi(Abu AlHassan)23-Feb-11 10:41 
GeneralRe: the opposite of Page_Validate Pin
Ali Al Omairi(Abu AlHassan)23-Feb-11 12:53
professionalAli Al Omairi(Abu AlHassan)23-Feb-11 12:53 
GeneralRe: the opposite of Page_Validate Pin
Bernhard Hiller23-Feb-11 20:12
Bernhard Hiller23-Feb-11 20:12 
AnswerRe: the opposite of Page_Validate Pin
bVagadishnu24-Feb-11 10:24
bVagadishnu24-Feb-11 10:24 
GeneralRe: the opposite of Page_Validate Pin
Ali Al Omairi(Abu AlHassan)25-Feb-11 7:31
professionalAli Al Omairi(Abu AlHassan)25-Feb-11 7:31 
QuestionUsing user accounts and permissions from custom database for authentication and authorisation in ASP.NET 4? [modified] Pin
kbalias21-Feb-11 23:55
kbalias21-Feb-11 23:55 
Hi everyone

I developed a Windows Application for the cancer department I am working in. It is a registry of all the patients that we see in the department and the doctors use it for stats and research. Patients are entered and edited in the system. There is also a reports system where users can create their own custom reports and safe the report parameters for future use.

I have done the user accounts such that a user can belong to more that one group. So a user might belong to the ‘Patients Admin’ group, the 'Data Admin' group and to the ‘Reports Admin’ group. Another user might belong to the ‘Patient Edit’ group and ‘Reports Admin’ group. A third user might only belong to the ‘Patient Open’ group. Thus depending on the group they belong to they can access certain areas and forms are only allowed certain actions. In other words some users might be able to access a screen/form to view the information, but cannot edit the information.

I am using a SQL Server 2008 Express database as the back-end. The user accounts (usernames and hashed passwords) and the Group details and Permissions details are also stored in the same database.

The structure is like the following:

CREATE TABLE [dbo].[Groups1]
(
[GID] [int] NOT NULL
PRIMARY KEY CLUSTERED,
[GroupName] [nvarchar](50) NOT NULL,
[Description] [nvarchar](150) NULL
)


CREATE TABLE [dbo].[Permissions1]
(
[PID] [int] NOT NULL
PRIMARY KEY CLUSTERED,
[Permission] [nvarchar](50) NOT NULL,
[Description] [nvarchar](150) NULL
)


CREATE TABLE [dbo].[Users1]
(
[UsID] [int] NOT NULL
PRIMARY KEY CLUSTERED,
[Username] [nvarchar](50) NOT NULL,
[UPassword] [nvarchar](50) NOT NULL
)


CREATE TABLE [dbo].[GroupPermissions1](

[GPID] [int] NOT NULL,
[FK_GID] [int] NOT NULL
FOREIGN KEY
REFERENCES Groups1 (GID),
[FK_PID] [int] NOT NULL
FOREIGN KEY
REFERENCES Permissions1 (PID)
)


CREATE TABLE [dbo].[UserGroups1]
(
[UGID] [int] NOT NULL,
[FK_UID] [int] NOT NULL
FOREIGN KEY
REFERENCES Users1 (UsID),
[FK_GID] [int] NOT NULL
FOREIGN KEY
REFERENCES Groups1 (GID)
)


I was asked to convert this Windows application to a Web application. Due to confidentiality issues regarding patient details I need to do authentication and authorization.

Is it possible to use this type of group and permissions structure in a web application?

If it is possible the next question is then how easy will it be implement the built-in login controls from ASP.NET with the user accounts, groups, and permissions in my custom database?

Kind regards.

Kobus
modified on Tuesday, February 22, 2011 6:28 AM

AnswerRe: Using user accounts and permissions from custom database for authentication and authorisation in ASP.NET 4? Pin
JV999923-Feb-11 3:07
professionalJV999923-Feb-11 3:07 
AnswerRe: Using user accounts and permissions from custom database for authentication and authorisation in ASP.NET 4? Pin
Lisa Z. Morgan23-Feb-11 6:07
Lisa Z. Morgan23-Feb-11 6:07 
QuestionPage methods subscribing to Control Events such as Load and PreRender Pin
swjam21-Feb-11 17:49
swjam21-Feb-11 17:49 
AnswerRe: Page methods subscribing to Control Events such as Load and PreRender Pin
senguptaamlan22-Feb-11 22:23
senguptaamlan22-Feb-11 22:23 
QuestionCreating an ASP.NET UserControl with collection-type property Pin
kensai21-Feb-11 3:47
kensai21-Feb-11 3:47 
AnswerRe: Creating an ASP.NET UserControl with collection-type property Pin
Ali Al Omairi(Abu AlHassan)22-Feb-11 4:38
professionalAli Al Omairi(Abu AlHassan)22-Feb-11 4:38 
Questionusing Microsoft.Office.Interop.Word + timeout Pin
Member 769046020-Feb-11 18:37
Member 769046020-Feb-11 18:37 
Questionhtml to code behind Pin
Ramkumar_S20-Feb-11 15:38
Ramkumar_S20-Feb-11 15:38 
AnswerRe: html to code behind [modified] Pin
Andy_L_J20-Feb-11 15:50
Andy_L_J20-Feb-11 15:50 
GeneralRe: html to code behind Pin
Not Active21-Feb-11 4:23
mentorNot Active21-Feb-11 4:23 
AnswerRe: html to code behind Pin
Anurag Gandhi20-Feb-11 22:43
professionalAnurag Gandhi20-Feb-11 22:43 
QuestionHelp in understanding PopupControlExtender Pin
simsen19-Feb-11 0:10
simsen19-Feb-11 0:10 
QuestionRe: Help in understanding PopupControlExtender Pin
Sunasara Imdadhusen21-Feb-11 23:22
professionalSunasara Imdadhusen21-Feb-11 23:22 
QuestionFormat Dynamic GridView at runtime Pin
Andy_L_J18-Feb-11 23:22
Andy_L_J18-Feb-11 23:22 
Questionc#+object copy Pin
Ramkumar_S18-Feb-11 16:30
Ramkumar_S18-Feb-11 16:30 
AnswerCross Post Pin
dan!sh 19-Feb-11 0:05
professional dan!sh 19-Feb-11 0:05 
QuestionRunning a web application on two windows Pin
xyz_999@hotmail.com18-Feb-11 5:19
xyz_999@hotmail.com18-Feb-11 5:19 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.