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 |
|
Muzza
Starting Member
3 Posts |
 Posted - 2004-12-07 : 08:00:27
|
| Hey, I am wondering if it is possible to register an mdf but then prevent viewing of the contents of the database through a client's enterprise manager - MS SQL 2000 is being used. It seems impossible to create a situation where the database is closed and the only access a client has got is through an application. I am sure one of you guys/gals will know. Thanks. |
|
|
tuenty
Constraint Violating Yak Guru
278 Posts |
Posted - 2004-12-07 : 08:48:26
|
| restrict users permisions on that specific Database. make sure nobody knows the sa password*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*A candle loses nothing by lighting another candle |
 |
|
|
Muzza
Starting Member
3 Posts |
Posted - 2004-12-07 : 11:59:50
|
| Thanks for the reply. So if we were adding the database to a client's system, there is no way we can restrict access to it as they would have already set up the sa account. Does the process of registering the database make it accessible to the sa account? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-12-07 : 12:08:29
|
| Yes it does. Why are you trying to prevent a client from viewing their own data? |
|
|
|
Muzza
Starting Member
3 Posts |
Posted - 2004-12-07 : 12:52:11
|
| It is not their own data which I want to prevent them from seeing. It is our configurable proprietary data that is enclosed within the database which I don't want them to see. I guess I will have to find a different way to store that data. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-12-07 : 13:01:57
|
| You can encrypt it or encode it, or store it outside the database. |
|
|
|
|
|
|
Security