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 |
|
cjp
Yak Posting Veteran
69 Posts |
 Posted - 2008-08-20 : 03:41:21
|
| I have read the thread on passwords but don't quite follow what is being said. What I actually need to do, if possible, is to password access to each database (just the data files would do) so that the database cannot be used unless the correct password is entered.At the moment, SQLS lets me in if I log on correctly to Windows but I really need the extra security of being able to prevent anyone else from accessing the data without the correct password.Is there a simple way to do this? - I am using SQLS 2005 SP 2.Thanks.Chris |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-20 : 09:01:29
|
| Restrict access to database for user and give them what they need. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-21 : 00:01:37
|
| Ensure don't put user in sysadmin server .role |
|
|
|
cjp
Yak Posting Veteran
69 Posts |
Posted - 2008-08-27 : 02:55:27
|
| Thanks for your suggestions.Chris |
|
|
|
|
|
|
Securing access to database