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 |
|
sunny_10
Yak Posting Veteran
72 Posts |
 Posted - 2014-07-09 : 05:48:46
|
| Hi I have 10-15 database . Is it possible to set password for a particular database.Thanks |
|
|
Shanky
Yak Posting Veteran
84 Posts |
Posted - 2014-07-09 : 07:08:11
|
| Hi,Password is not set for database its set for logins. What do you want to achieve can you please elaborate.RegardsShankyhttp://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx |
 |
|
|
sunny_10
Yak Posting Veteran
72 Posts |
Posted - 2014-07-11 : 02:13:48
|
| Hi I require this because i have installed Database on some other Company's Server . They have their own database also.Thanks |
|
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2014-07-11 : 08:52:14
|
| If it is on another company's server and assuming that the system admins are that company's employees, there is nothing much you can do to prevent them accessing your database or doing whatever they please with the database. You can try to encrypt tables etc., but it is not foolproof. |
|
|
|
Shanky
Yak Posting Veteran
84 Posts |
Posted - 2014-07-13 : 05:43:00
|
| What made you share your database to some other firm. As already mentioned there is no full proof to avoid access to database. You should ask other party to sign non disclosure agreement.RegardsShankyhttp://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx |
|
|
|
|
|
|
Database Password