Click here to Skip to main content
15,850,359 members
Home / Discussions / Database
   

Database

 
Questionstop accessing peoples SQL server through SQL management Studio. Pin
Azam Niaz Ch.21-Jun-15 10:06
Azam Niaz Ch.21-Jun-15 10:06 
AnswerRe: stop accessing peoples SQL server through SQL management Studio. Pin
PIEBALDconsult21-Jun-15 10:24
mvePIEBALDconsult21-Jun-15 10:24 
GeneralRe: stop accessing peoples SQL server through SQL management Studio. Pin
Azam Niaz Ch.21-Jun-15 19:21
Azam Niaz Ch.21-Jun-15 19:21 
GeneralRe: stop accessing peoples SQL server through SQL management Studio. Pin
PIEBALDconsult21-Jun-15 19:28
mvePIEBALDconsult21-Jun-15 19:28 
GeneralRe: stop accessing peoples SQL server through SQL management Studio. Pin
scottgp22-Jun-15 2:19
professionalscottgp22-Jun-15 2:19 
GeneralRe: stop accessing peoples SQL server through SQL management Studio. Pin
Eddy Vluggen22-Jun-15 2:36
professionalEddy Vluggen22-Jun-15 2:36 
AnswerRe: stop accessing peoples SQL server through SQL management Studio. Pin
Mycroft Holmes21-Jun-15 20:57
professionalMycroft Holmes21-Jun-15 20:57 
AnswerRe: stop accessing peoples SQL server through SQL management Studio. Pin
GuyThiebaut21-Jun-15 22:24
professionalGuyThiebaut21-Jun-15 22:24 
The quickish and simple way:

(1) remove SSMS from their computers
(2) restrict access to the server so that they can only access views and cannot perform any updates, inserts or deletes or do anything else for that matter - views only, that's a simple way of providing more security.

Notes: given (2), (1) is not strictly necessary, however the only people using SSMS should be the DBAs so it is probably best to get people out of the habit of having access to it(I know... if people download Toad they will have similar features available).
“That which can be asserted without evidence, can be dismissed without evidence.”

― Christopher Hitchens

GeneralRe: stop accessing peoples SQL server through SQL management Studio. Pin
Mycroft Holmes22-Jun-15 15:13
professionalMycroft Holmes22-Jun-15 15:13 
QuestionMaximum stored procedure, function, trigger, or view nesting level exceeded (limit 32) Pin
indian14319-Jun-15 16:46
indian14319-Jun-15 16:46 
AnswerRe: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32) Pin
Richard Deeming22-Jun-15 2:41
mveRichard Deeming22-Jun-15 2:41 
GeneralRe: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32) Pin
indian14322-Jun-15 8:00
indian14322-Jun-15 8:00 
QuestionHow to add primary key in existing table? Pin
apple blue16-Jun-15 17:53
apple blue16-Jun-15 17:53 
AnswerRe: How to add primary key in existing table? Pin
Peter Leow16-Jun-15 18:07
professionalPeter Leow16-Jun-15 18:07 
GeneralRe: How to add primary key in existing table? Pin
apple blue16-Jun-15 19:37
apple blue16-Jun-15 19:37 
AnswerRe: How to add primary key in existing table? Pin
Dhamodharan A18-Jun-15 22:33
Dhamodharan A18-Jun-15 22:33 
GeneralRe: How to add primary key in existing table? Pin
apple blue29-Jun-15 15:48
apple blue29-Jun-15 15:48 
AnswerRe: How to add primary key in existing table? Pin
Daniel Miller23-Oct-15 16:32
professionalDaniel Miller23-Oct-15 16:32 
Questioninterface a c# application and SCADA system using SQL server Pin
zineb errih16-Jun-15 8:36
zineb errih16-Jun-15 8:36 
AnswerRe: interface a c# application and SCADA system using SQL server Pin
Hernan Osorio6-Oct-17 7:30
Hernan Osorio6-Oct-17 7:30 
QuestionQuery Response Time - SQL Server Replication Pin
JammoD8714-Jun-15 2:48
JammoD8714-Jun-15 2:48 
AnswerRe: Query Response Time - SQL Server Replication Pin
Mycroft Holmes14-Jun-15 14:03
professionalMycroft Holmes14-Jun-15 14:03 
AnswerRe: Query Response Time - SQL Server Replication Pin
GuyThiebaut14-Jun-15 22:25
professionalGuyThiebaut14-Jun-15 22:25 
AnswerRe: Query Response Time - SQL Server Replication Pin
Tim Carmichael15-Jun-15 10:06
Tim Carmichael15-Jun-15 10:06 
AnswerRe: Query Response Time - SQL Server Replication Pin
JammoD8716-Jun-15 2:16
JammoD8716-Jun-15 2:16 

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.