Click here to Skip to main content
15,878,809 members
Home / Discussions / Database
   

Database

 
QuestionRead Only Database Pin
Bastien Vandamme22-Jun-14 18:43
Bastien Vandamme22-Jun-14 18:43 
AnswerRe: Read Only Database Pin
Kornfeld Eliyahu Peter22-Jun-14 19:40
professionalKornfeld Eliyahu Peter22-Jun-14 19:40 
AnswerRe: Read Only Database Pin
Jörgen Andersson22-Jun-14 20:21
professionalJörgen Andersson22-Jun-14 20:21 
AnswerRe: Read Only Database Pin
Mycroft Holmes23-Jun-14 1:13
professionalMycroft Holmes23-Jun-14 1:13 
GeneralRe: Read Only Database Pin
Jörgen Andersson23-Jun-14 1:18
professionalJörgen Andersson23-Jun-14 1:18 
GeneralRe: Read Only Database Pin
Mycroft Holmes25-Jun-14 0:26
professionalMycroft Holmes25-Jun-14 0:26 
GeneralRe: Read Only Database Pin
Jörgen Andersson25-Jun-14 9:53
professionalJörgen Andersson25-Jun-14 9:53 
GeneralRe: Read Only Database Pin
Bastien Vandamme23-Jun-14 16:44
Bastien Vandamme23-Jun-14 16:44 
What you suggest is one of my possibilities but I would like to investigate on the possibility only to allow INSERT and SELECT.

I my case I need to prove that NOBODY can never hack the system and modify a tracking data. A trigger can be deactivated. I would like to GRANT only INSERT and SELECT to all users.

I saw system build for FDA rules where developers or DBA can still have all the power on production database and I saw them removing audit data on production. Wrong and testing data in this case but where is the limit between this and falsification.
GeneralRe: Read Only Database Pin
Mycroft Holmes25-Jun-14 0:35
professionalMycroft Holmes25-Jun-14 0:35 
GeneralRe: Read Only Database Pin
Bastien Vandamme26-Jun-14 0:02
Bastien Vandamme26-Jun-14 0:02 
QuestionGet the max elements in a join? Pin
Bastien Vandamme22-Jun-14 17:14
Bastien Vandamme22-Jun-14 17:14 
AnswerRe: Get the max elements in a join? Pin
Kornfeld Eliyahu Peter22-Jun-14 19:31
professionalKornfeld Eliyahu Peter22-Jun-14 19:31 
AnswerRe: Get the max elements in a join? Pin
Jörgen Andersson22-Jun-14 20:08
professionalJörgen Andersson22-Jun-14 20:08 
QuestionIs it recommended to use trigger to manage business rules with SQL Server? Pin
Bastien Vandamme22-Jun-14 17:00
Bastien Vandamme22-Jun-14 17:00 
AnswerRe: Is it recommended to use trigger to manage business rules with SQL Server? Pin
Kornfeld Eliyahu Peter22-Jun-14 19:15
professionalKornfeld Eliyahu Peter22-Jun-14 19:15 
GeneralRe: Is it recommended to use trigger to manage business rules with SQL Server? Pin
GuyThiebaut22-Jun-14 21:59
professionalGuyThiebaut22-Jun-14 21:59 
GeneralRe: Is it recommended to use trigger to manage business rules with SQL Server? Pin
Kornfeld Eliyahu Peter22-Jun-14 22:02
professionalKornfeld Eliyahu Peter22-Jun-14 22:02 
GeneralRe: Is it recommended to use trigger to manage business rules with SQL Server? Pin
Jörgen Andersson22-Jun-14 22:20
professionalJörgen Andersson22-Jun-14 22:20 
GeneralRe: Is it recommended to use trigger to manage business rules with SQL Server? Pin
Kornfeld Eliyahu Peter22-Jun-14 22:21
professionalKornfeld Eliyahu Peter22-Jun-14 22:21 
GeneralRe: Is it recommended to use trigger to manage business rules with SQL Server? Pin
Jörgen Andersson22-Jun-14 22:24
professionalJörgen Andersson22-Jun-14 22:24 
GeneralRe: Is it recommended to use trigger to manage business rules with SQL Server? Pin
Kornfeld Eliyahu Peter22-Jun-14 22:28
professionalKornfeld Eliyahu Peter22-Jun-14 22:28 
AnswerRe: Is it recommended to use trigger to manage business rules with SQL Server? Pin
Jörgen Andersson22-Jun-14 19:52
professionalJörgen Andersson22-Jun-14 19:52 
AnswerRe: Is it recommended to use trigger to manage business rules with SQL Server? Pin
Mycroft Holmes23-Jun-14 1:04
professionalMycroft Holmes23-Jun-14 1:04 
QuestionCompare two tabel and add/update query Pin
member002618-Jun-14 20:44
member002618-Jun-14 20:44 
AnswerRe: Compare two tabel and add/update query Pin
Mycroft Holmes18-Jun-14 22:33
professionalMycroft Holmes18-Jun-14 22:33 

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.