Click here to Skip to main content
15,919,178 members
Home / Discussions / Database
   

Database

 
GeneralRe: stored procedures Pin
Paul.B18-Sep-07 22:57
Paul.B18-Sep-07 22:57 
GeneralRe: stored procedures Pin
Giorgi Dalakishvili18-Sep-07 23:19
mentorGiorgi Dalakishvili18-Sep-07 23:19 
GeneralRe: stored procedures Pin
Paul.B18-Sep-07 23:27
Paul.B18-Sep-07 23:27 
AnswerRe: stored procedures Pin
amraouf15-Sep-07 22:10
amraouf15-Sep-07 22:10 
Questionis there any possibility raise a problem Pin
prasadbuddhika14-Sep-07 21:29
prasadbuddhika14-Sep-07 21:29 
AnswerRe: is there any possibility raise a problem Pin
Paul Conrad15-Sep-07 4:07
professionalPaul Conrad15-Sep-07 4:07 
GeneralRe: is there any possibility raise a problem Pin
prasadbuddhika15-Sep-07 16:54
prasadbuddhika15-Sep-07 16:54 
QuestionSQL Security for your apps Pin
Mark Cabbage14-Sep-07 20:06
Mark Cabbage14-Sep-07 20:06 
Hi everyone,

I was wondering how you all went about connecting to your databases from a security point of view. Some people say to use the SA password and embed security in your app with internal usernames/passwords, while others use Windows Security.

I think the SA password idea sounds simplier, and has the advantage of being able to limit what data the user gets to (eg: which clients information they can see) HOWEVER it doesn't stop someone using the password with MS Access to bypass your app and get the data.

So I was thinking the integrated security is best, and like any security, the use of groups would be best. My issue then becomes how to use those groups in SQL / VB.NET to enforce security, especially how would I enforce record level security (eg: which clients information they can see)

Thoughts everyone ??
AnswerRe: SQL Security for your apps Pin
Paul Conrad15-Sep-07 4:04
professionalPaul Conrad15-Sep-07 4:04 
GeneralRe: SQL Security for your apps Pin
Mark Cabbage15-Sep-07 4:49
Mark Cabbage15-Sep-07 4:49 
AnswerRe: SQL Security for your apps Pin
Mike Dimmick16-Sep-07 6:37
Mike Dimmick16-Sep-07 6:37 
GeneralRe: SQL Security for your apps Pin
Mark Cabbage16-Sep-07 15:24
Mark Cabbage16-Sep-07 15:24 
QuestionProblem with populating the FullText search Catalog Pin
Splunk14-Sep-07 7:47
Splunk14-Sep-07 7:47 
AnswerRe: Problem with populating the FullText search Catalog Pin
DerekFL14-Sep-07 7:58
DerekFL14-Sep-07 7:58 
QuestionNew rows that are added don't increment the PK field Pin
steve_rm14-Sep-07 3:17
steve_rm14-Sep-07 3:17 
AnswerRe: New rows that are added don't increment the PK field Pin
Michael Potter14-Sep-07 4:08
Michael Potter14-Sep-07 4:08 
QuestionRe: New rows that are added don't increment the PK field Pin
steve_rm14-Sep-07 7:52
steve_rm14-Sep-07 7:52 
AnswerRe: New rows that are added don't increment the PK field Pin
Michael Potter14-Sep-07 8:33
Michael Potter14-Sep-07 8:33 
QuestionRe: New rows that are added don't increment the PK field Pin
steve_rm14-Sep-07 19:01
steve_rm14-Sep-07 19:01 
QuestionRe: New rows that are added don't increment the PK field Pin
steve_rm16-Sep-07 0:33
steve_rm16-Sep-07 0:33 
GeneralRequesting for a link for web services basics... Pin
Sushil D Jadhav14-Sep-07 0:26
Sushil D Jadhav14-Sep-07 0:26 
GeneralRe: Requesting for a link for web services basics... Pin
Pete O'Hanlon14-Sep-07 1:41
mvePete O'Hanlon14-Sep-07 1:41 
QuestionADO.NET free E-books Pin
Vimalsoft(Pty) Ltd14-Sep-07 0:04
professionalVimalsoft(Pty) Ltd14-Sep-07 0:04 
AnswerRe: ADO.NET free E-books Pin
Pete O'Hanlon14-Sep-07 3:46
mvePete O'Hanlon14-Sep-07 3:46 
GeneralRe: ADO.NET free E-books Pin
Vimalsoft(Pty) Ltd14-Sep-07 4:21
professionalVimalsoft(Pty) Ltd14-Sep-07 4:21 

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.