Click here to Skip to main content
15,886,963 members
Home / Discussions / Database
   

Database

 
GeneralRe: how to select last row on second CTE Pin
Jörgen Andersson29-Sep-14 5:50
professionalJörgen Andersson29-Sep-14 5:50 
QuestionMS Server - Lock a record Pin
hansoctantan26-Sep-14 3:48
professionalhansoctantan26-Sep-14 3:48 
QuestionRe: MS Server - Lock a record Pin
ZurdoDev26-Sep-14 4:22
professionalZurdoDev26-Sep-14 4:22 
AnswerRe: MS Server - Lock a record Pin
PIEBALDconsult26-Sep-14 4:24
mvePIEBALDconsult26-Sep-14 4:24 
AnswerRe: MS Server - Lock a record Pin
Eddy Vluggen26-Sep-14 6:15
professionalEddy Vluggen26-Sep-14 6:15 
AnswerRe: MS Server - Lock a record Pin
jschell26-Sep-14 10:44
jschell26-Sep-14 10:44 
AnswerRe: MS Server - Lock a record Pin
Wendelius30-Sep-14 8:28
mentorWendelius30-Sep-14 8:28 
QuestionProtect my sql server database Pin
dilkonika23-Sep-14 15:44
dilkonika23-Sep-14 15:44 
Hello !

I have created an application that use a sql server database.

But the problem is that a user can open sql server management studio and can do anything that I don't like , for example :

1) Can modify values inside tables.

2) can delete records

3) Can see and can get my database structure.....

......

How can I protect my database , so that users can modify this database only inside my application , and can do anything outside my application ? I don't know does exist a way to protect my database with a password or.... ??? for example when I was using Access for database , i have protected Access files with a password , and after only my application can open this database .
Is possible to include a protection in the sql server database file ( so even the file is imported to another computer to remain protected ?

I have a specific situation :

My application is designated to manage several "office".

In my application folder , i have a empty backup file ( offline) of my database called "Model". And inside my application a user can create "A new office " and when he do this the application restore a copy of "Model" inside sql server with a specific name (for example "Office1". Another time the user can create another "Office" using again a copy of "Model"

So inside Sql server may be different databases ( all of them with the same structure ) like "Model"

So in this situation how can i Protect my databases and the "Model" .

Because i think i should apply a Protection" inside the offline backup file "Model" ( if it's possible , all the databases that have created from "Model" will have the protection ) or ??????

What should i do in this case ?

Thank you !

modified 23-Sep-14 22:23pm.

AnswerRe: Protect my sql server database Pin
Mycroft Holmes23-Sep-14 16:57
professionalMycroft Holmes23-Sep-14 16:57 
GeneralRe: Protect my sql server database Pin
Richard Deeming24-Sep-14 1:27
mveRichard Deeming24-Sep-14 1:27 
AnswerRe: Protect my sql server database Pin
Eddy Vluggen23-Sep-14 21:10
professionalEddy Vluggen23-Sep-14 21:10 
GeneralRe: Protect my sql server database Pin
dilkonika24-Sep-14 3:13
dilkonika24-Sep-14 3:13 
GeneralRe: Protect my sql server database Pin
Eddy Vluggen24-Sep-14 6:21
professionalEddy Vluggen24-Sep-14 6:21 
GeneralRe: Protect my sql server database Pin
dilkonika24-Sep-14 13:30
dilkonika24-Sep-14 13:30 
GeneralRe: Protect my sql server database Pin
Eddy Vluggen25-Sep-14 1:53
professionalEddy Vluggen25-Sep-14 1:53 
AnswerRe: Protect my sql server database Pin
Corporal Agarn24-Sep-14 4:33
professionalCorporal Agarn24-Sep-14 4:33 
GeneralRe: Protect my sql server database Pin
dilkonika24-Sep-14 6:18
dilkonika24-Sep-14 6:18 
AnswerRe: Protect my sql server database Pin
data modeling guy29-Sep-14 6:58
data modeling guy29-Sep-14 6:58 
AnswerRe: Protect my sql server database Pin
Wendelius30-Sep-14 8:59
mentorWendelius30-Sep-14 8:59 
QuestionSQL Server : Multiple relationship for the same field Pin
dilkonika23-Sep-14 7:29
dilkonika23-Sep-14 7:29 
AnswerRe: SQL Server : Multiple relationship for the same field Pin
Wendelius23-Sep-14 8:04
mentorWendelius23-Sep-14 8:04 
GeneralRe: SQL Server : Multiple relationship for the same field Pin
dilkonika23-Sep-14 8:14
dilkonika23-Sep-14 8:14 
AnswerRe: SQL Server : Multiple relationship for the same field Pin
Wendelius23-Sep-14 8:33
mentorWendelius23-Sep-14 8:33 
AnswerRe: SQL Server : Multiple relationship for the same field Pin
Mycroft Holmes23-Sep-14 14:19
professionalMycroft Holmes23-Sep-14 14:19 
AnswerRe: SQL Server : Multiple relationship for the same field Pin
data modeling guy29-Sep-14 5:02
data modeling guy29-Sep-14 5:02 

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.