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 |
|
asm
Posting Yak Master
140 Posts |
 Posted - 2006-10-12 : 03:09:55
|
| HiI want to protech a particular database in SQL server with Password. Can it Possible.. ThanksASM |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2006-10-12 : 03:43:49
|
| It depends on what you mean by protect and from who. It's impossible to access sql server without authentication of some sort so you could create a sql server user with a username/password, but anyone with i.e. system administrator priveleges on that server will still be able to access.--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-10-12 : 03:51:23
|
| You can password protect individual database but you can prevent unwanted users from viewing your database structure or contents by giving/denying appropriate permissions.Read about Security Architecture in BOL.Harsh AthalyeIndia."Nothing is Impossible" |
|
|
|
|
|
|
Database Password