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 |
|
mamzy
Starting Member
4 Posts |
 Posted - 2005-03-20 : 00:33:04
|
| HI,I have databases over the network,clients using these database through there applications and using ODBC as the connections to the databases,also clients having MS Access ,MS Word and MS Excel,the problem they can use these MS Office to import the data form the databses using the ODBC profiles from ther Workstations,please any ideas to prevent the clients from using ODBC profiles on there PC's to import data from DB's.help appriciated...... |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-03-20 : 02:45:31
|
| Build a login into the application (either a specific SQL login, which the user does not see, or a User + Password table and your own login and a single database login for all users [hardwired into the application]), so that the user's login is not actually the database loginProvide VIEWs for data which the user CAN acces from other tools - such as Word. Only give the user SELECT permissions on the views. Or use DataReader role only (i.e. SELECT access on ALL tables/views)Kristen |
 |
|
|
|
|
|
ODBC & SQL Database