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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2006-08-09 : 09:34:14
|
| Saeed writes "Dear brothers i make a project in vb 6 as front end and SQL Server as Back end and i easily created pacage of vb project but i have to give sql server databases to the person to run vb Project but i want that he cant view my Tables.Means he should not install sql server enterprise manager." |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-09 : 10:22:49
|
| Can't stop someone installing enterprise manager.Doesn't matter anyway as you can see the tables if you have permission on the database.Only way would be to install sql server on his system using sql server security (no integrated security logins), have the password only known to your application. Then he can't log in to the server without your app.Means that you own the server and they don't have any other access to it.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|