Click here to Skip to main content
15,898,996 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
AnswerRe: Estimate the cost of a Software application Pin
JV999925-Feb-11 4:43
professionalJV999925-Feb-11 4:43 
GeneralRe: Estimate the cost of a Software application Pin
nz_hmz25-Feb-11 5:46
nz_hmz25-Feb-11 5:46 
GeneralRe: Estimate the cost of a Software application Pin
Mycroft Holmes25-Feb-11 18:35
professionalMycroft Holmes25-Feb-11 18:35 
AnswerRe: Estimate the cost of a Software application Pin
Eddy Vluggen25-Feb-11 23:10
professionalEddy Vluggen25-Feb-11 23:10 
AnswerRe: Estimate the cost of a Software application Pin
RobCroll27-Feb-11 0:07
RobCroll27-Feb-11 0:07 
GeneralRe: Estimate the cost of a Software application Pin
grmihel28-Mar-11 22:27
grmihel28-Mar-11 22:27 
AnswerRe: Estimate the cost of a Software application Pin
Piccadilly Yum Yum3-Mar-11 2:24
Piccadilly Yum Yum3-Mar-11 2:24 
QuestionUnified System Security Design - Database / Code / Both! Pin
Jammer13-Feb-11 7:51
Jammer13-Feb-11 7:51 
Hi All,

I'm in the middle of making a complete demo system (possibly for a new Code Project article but more for practice at the moment) whose design should be very robust and scalable. I have a question regarding security and how best to implement it, not on a detail level but a high level design bases. The security is going to be pretty run of the mill stuff, hashed passwords, users, roles, permissions.

The system currently uses the AdventureWorks demo database for it's data and comprises the following components:

Database SQL 2008 R2 (Express)
DAL (using LinqToSQL but will migrate it to use Entity Framework)
Wpf Client (using PRISM)
Silverlight Client (using PRISM)
WCF Services

Basically I want a unified security model so that all code components (or future components) will use exactly the same security mechanisms. Which leads on to the first question. In the past I have created separate security databases and also just created tables in an existing schema to support the required security model. I would ideally like to be able to assert that the calling user has rights at the stored procedure level AND at the code level but by having a separate database for security means that that the data database starts to have a dependency on the security database which I'm not a far of.

Baring in mind that there will be plenty of security going on at the code level does the database even need to worry about rights? Some projects I've worked on have insisted on this level of security. I would ultimately prefer security at both levels so even if someone managed to get a connection to it they still have barriers to getting anything meaningful out of it.

Any thoughts on this or links to good reading would be appreciated.

Cheers,

AnswerRe: Unified System Security Design - Database / Code / Both! Pin
Manfred Rudolf Bihy13-Feb-11 10:37
professionalManfred Rudolf Bihy13-Feb-11 10:37 
GeneralRe: Unified System Security Design - Database / Code / Both! Pin
Jammer15-Feb-11 4:04
Jammer15-Feb-11 4:04 
QuestionIs MSMQ old school Pin
RobCroll1-Feb-11 0:08
RobCroll1-Feb-11 0:08 
AnswerRe: Is MSMQ old school Pin
Pete O'Hanlon1-Feb-11 0:14
mvePete O'Hanlon1-Feb-11 0:14 
QuestionDatabase UI Design Pin
Leslie Sanford29-Jan-11 8:33
Leslie Sanford29-Jan-11 8:33 
AnswerRe: Database UI Design Pin
Praveen Raghuvanshi30-Jan-11 5:47
professionalPraveen Raghuvanshi30-Jan-11 5:47 
AnswerRe: Database UI Design Pin
David Skelly31-Jan-11 2:39
David Skelly31-Jan-11 2:39 
AnswerRe: Database UI Design Pin
RobCroll1-Feb-11 0:04
RobCroll1-Feb-11 0:04 
AnswerRe: Database UI Design Pin
Eddy Vluggen4-Feb-11 11:21
professionalEddy Vluggen4-Feb-11 11:21 
AnswerRe: Database UI Design Pin
nforlando2-Mar-11 3:26
nforlando2-Mar-11 3:26 
AnswerRe: Database UI Design Pin
Piccadilly Yum Yum3-Mar-11 2:36
Piccadilly Yum Yum3-Mar-11 2:36 
QuestionPOP3 Components Pin
Jammer28-Jan-11 0:42
Jammer28-Jan-11 0:42 
AnswerRe: POP3 Components Pin
phil.o28-Jan-11 2:38
professionalphil.o28-Jan-11 2:38 
JokeRe: POP3 Components Pin
Jammer28-Jan-11 3:33
Jammer28-Jan-11 3:33 
GeneralRe: POP3 Components Pin
phil.o28-Jan-11 4:06
professionalphil.o28-Jan-11 4:06 
AnswerRe: POP3 Components Pin
Hans Dietrich4-Feb-11 12:00
mentorHans Dietrich4-Feb-11 12:00 
AnswerRe: POP3 Components Pin
Jammer13-Feb-11 23:56
Jammer13-Feb-11 23:56 

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.