Click here to Skip to main content
15,849,678 members
Home / Discussions / Database
   

Database

 
AnswerRe: SQL SERVER DATABASE [modified] Pin
Syed Mehroz Alam14-Jul-08 1:42
Syed Mehroz Alam14-Jul-08 1:42 
Questiongeneralized statements for update delete insert Pin
santosh04213-Jul-08 22:37
santosh04213-Jul-08 22:37 
AnswerRe: generalized statements for update delete insert Pin
Ashfield14-Jul-08 2:14
Ashfield14-Jul-08 2:14 
GeneralRe: generalized statements for update delete insert Pin
santosh04214-Jul-08 5:11
santosh04214-Jul-08 5:11 
AnswerRe: generalized statements for update delete insert Pin
leoinfo14-Jul-08 5:27
leoinfo14-Jul-08 5:27 
Questionconnection string Pin
nelsonpaixao13-Jul-08 16:06
nelsonpaixao13-Jul-08 16:06 
AnswerRe: connection string Pin
Vimalsoft(Pty) Ltd13-Jul-08 16:48
professionalVimalsoft(Pty) Ltd13-Jul-08 16:48 
AnswerRe: connection string Pin
Ashfield13-Jul-08 22:01
Ashfield13-Jul-08 22:01 
Hi
I already answered your first post on this, I'm sorry if you don't understand but here it isagain:

The best option in my opinion is to use windows groups to limit user access. It still uses windows authentication so no password verification etc, and you can then grant explicit permissions to the group. You can deny permissions as well as grant them, so deny select, insert, update, delete on your tables and grant exec on the stored procs.

Its a standard way of doing it and easy to maintain by scripts.


nelsonpaixao wrote:
The login to the application is wrote not in C# but SQL store procedures. I press a buttom that triggers a SP that manages the login. my connection strings have both no password and user.


From this I must assume you are alreay using windows authentication, so you need to set the table permissions as I said. This will prevent someone attaching to you database and seeing the tables. I'm not sure how to explain thsi any clearer, but try google for granting permissions in sql server, it may help your understanding.

Bob
Ashfield Consultants Ltd

GeneralRe: connection string Pin
nelsonpaixao14-Jul-08 14:11
nelsonpaixao14-Jul-08 14:11 
Questionhelp me to write procedure Pin
amistry_petlad13-Jul-08 8:40
amistry_petlad13-Jul-08 8:40 
AnswerRe: help me to write procedure Pin
nelsonpaixao13-Jul-08 14:35
nelsonpaixao13-Jul-08 14:35 
AnswerRe: help me to write procedure Pin
amistry_petlad13-Jul-08 14:41
amistry_petlad13-Jul-08 14:41 
AnswerRe: help me to write procedure Pin
nelsonpaixao13-Jul-08 15:37
nelsonpaixao13-Jul-08 15:37 
GeneralRe: help me to write procedure Pin
amistry_petlad13-Jul-08 15:47
amistry_petlad13-Jul-08 15:47 
AnswerRe: help me to write procedure Pin
leoinfo13-Jul-08 18:21
leoinfo13-Jul-08 18:21 
GeneralRe: help me to write procedure Pin
amistry_petlad13-Jul-08 18:57
amistry_petlad13-Jul-08 18:57 
GeneralRe: help me to write procedure Pin
Paul Conrad13-Jul-08 19:06
professionalPaul Conrad13-Jul-08 19:06 
GeneralRe: help me to write procedure Pin
amistry_petlad13-Jul-08 19:12
amistry_petlad13-Jul-08 19:12 
GeneralRe: help me to write procedure Pin
Paul Conrad13-Jul-08 19:16
professionalPaul Conrad13-Jul-08 19:16 
GeneralRe: help me to write procedure Pin
nelsonpaixao13-Jul-08 16:12
nelsonpaixao13-Jul-08 16:12 
GeneralRe: help me to write procedure Pin
amistry_petlad13-Jul-08 18:58
amistry_petlad13-Jul-08 18:58 
Questiondecimal not show zero [modified] Pin
tai-fun12-Jul-08 4:38
tai-fun12-Jul-08 4:38 
AnswerRe: decimal not show zero Pin
leoinfo12-Jul-08 8:07
leoinfo12-Jul-08 8:07 
Questionrow to column in sql Pin
ravindra_ee24811-Jul-08 20:58
ravindra_ee24811-Jul-08 20:58 
AnswerRe: row to column in sql Pin
Vimalsoft(Pty) Ltd13-Jul-08 16:55
professionalVimalsoft(Pty) Ltd13-Jul-08 16:55 

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.