Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-04-18 : 12:03:27
|
| Liesure writes "First Question.1. From SQl Server security, How can i restrict/allow an application (.exe file) to use the database/tablesI have an scenerio where i want to give access to some selected applications. Even user cannot access my database using Enterprise Manager or Query Analyzer.How can i do this? Please Help.2. I Have a very sensitive/confidential data, and i dont want that my DBA should see my data but he can Manage Data Backups and recovery tasks, He can create or alter tables,Tune database and so on... The Main purpose is that My DBA should not be able to see the actual records in a table.How can i do this? Please Help" |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-04-18 : 21:36:22
|
| 1. ask your DBA to create logins and provide the necessary permissions2. encrypt the data when you save them in the table--------------------keeping it simple... |
 |
|
|
|
|
|
sql server security