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 |
|
sapator
Constraint Violating Yak Guru
462 Posts |
 Posted - 2011-05-18 : 22:25:49
|
| Hi.It can be done in compact edition:http://technet.microsoft.com/en-us/library/ms171741%28SQL.90%29.aspxMy question is if it can be done in 2005 standard edition.Thanks. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-05-18 : 22:46:42
|
| SQL Server uses logins to control access, these logins may have passwords assigned. Furthermore, access is granted or denied to a database and its objects at various levels. It's a lot more granular and secure than a single database password.You can find more information here and in its related links: http://msdn.microsoft.com/en-us/library/ms181127.aspx |
 |
|
|
sapator
Constraint Violating Yak Guru
462 Posts |
Posted - 2011-05-19 : 00:18:10
|
| Thanks 'm aware and i use login's but i'm not sure about one thing.If someone is able to get your database (say he stole a backup mdb) will he be able to retrieve the data by simply restore it to his sql? |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-05-19 : 01:28:15
|
| If they restore the backup onto the SQL Server , and logon successfully- particuarly with a logon account with elevated privileges , then data is accessible. Ensure that strong passwords are used for SQL Server accounts - particuarly "sa"Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
sapator
Constraint Violating Yak Guru
462 Posts |
Posted - 2011-05-19 : 02:41:36
|
| Thanks. |
|
|
|
|
|
|
protect database with password