Click here to Skip to main content
15,918,668 members
Home / Discussions / Database
   

Database

 
Questionhow to use index? very simple i want some basic information........... Pin
Shaik Haneef9-Jul-08 20:27
Shaik Haneef9-Jul-08 20:27 
AnswerRe: how to use index? very simple i want some basic information........... Pin
Paddy Boyd9-Jul-08 20:54
Paddy Boyd9-Jul-08 20:54 
AnswerRe: how to use index? very simple i want some basic information........... Pin
Ashfield9-Jul-08 21:13
Ashfield9-Jul-08 21:13 
QuestionTransaction (Process ID 156) was deadlocked on lock Pin
sujithkumarsl9-Jul-08 18:23
sujithkumarsl9-Jul-08 18:23 
AnswerRe: Transaction (Process ID 156) was deadlocked on lock Pin
Ashfield9-Jul-08 21:22
Ashfield9-Jul-08 21:22 
Questiondatabase conection_string Pin
nelsonpaixao9-Jul-08 13:56
nelsonpaixao9-Jul-08 13:56 
AnswerRe: database conection_string Pin
Paddy Boyd9-Jul-08 20:59
Paddy Boyd9-Jul-08 20:59 
AnswerRe: database conection_string Pin
Ashfield9-Jul-08 21:17
Ashfield9-Jul-08 21:17 
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.

Bob
Ashfield Consultants Ltd

QuestionSQL FOR XML issue [modified] Pin
DerekFL9-Jul-08 7:59
DerekFL9-Jul-08 7:59 
AnswerRe: SQL FOR XML issue Pin
leoinfo9-Jul-08 9:26
leoinfo9-Jul-08 9:26 
QuestionDataTable validation event Pin
benallen0029-Jul-08 7:54
benallen0029-Jul-08 7:54 
AnswerRe: DataTable validation event Pin
DerekFL9-Jul-08 8:05
DerekFL9-Jul-08 8:05 
QuestionGetting the value of a primary key that is an Identity field Pin
LongRange.Shooter9-Jul-08 6:26
LongRange.Shooter9-Jul-08 6:26 
AnswerRe: Getting the value of a primary key that is an Identity field Pin
leoinfo9-Jul-08 6:56
leoinfo9-Jul-08 6:56 
QuestionCan't find SSIS or SSRS Pin
meeram3959-Jul-08 0:12
meeram3959-Jul-08 0:12 
AnswerRe: Can't find SSIS or SSRS Pin
Jerry Hammond9-Jul-08 3:03
Jerry Hammond9-Jul-08 3:03 
Questionhelp me please Pin
loscalibros9-Jul-08 0:08
loscalibros9-Jul-08 0:08 
AnswerRe: help me please [modified] Pin
meeram3959-Jul-08 0:41
meeram3959-Jul-08 0:41 
QuestionSending XML as input to Oracle stored procedure Pin
kalyan_vb8-Jul-08 23:48
kalyan_vb8-Jul-08 23:48 
Questiondefault settings SQL Server does not allow remote connections. Pin
Amit Agarrwal8-Jul-08 23:19
Amit Agarrwal8-Jul-08 23:19 
AnswerRe: default settings SQL Server does not allow remote connections. Pin
subai9-Jul-08 2:59
subai9-Jul-08 2:59 
QuestionHow to find the Table exists in a Data Base Pin
pallaka8-Jul-08 22:16
pallaka8-Jul-08 22:16 
AnswerRe: How to find the Table exists in a Data Base Pin
Ashfield8-Jul-08 22:47
Ashfield8-Jul-08 22:47 
GeneralRe: How to find the Table exists in a Data Base Pin
TheFM2349-Jul-08 4:46
TheFM2349-Jul-08 4:46 
QuestionChanging between mssql and access through connection string Pin
Y_R8-Jul-08 22:10
Y_R8-Jul-08 22:10 

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.