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 |
|
sand-lakes1
Starting Member
29 Posts |
 Posted - 2002-05-07 : 06:03:09
|
| Dear all,We are using sql 7.0. Many people agree it is the best way to have data on one location; they agreed to link to the tables. That is what we wanted.What happens right now is that a growing number of users is importing huge tables on a frequent base. This is what we would like to restrict.Linking tables would be the only way to use sql server and not importing. For example ms-access is used to import.Is there a way to restrict the import functionality on the client or the sql server.Thanks for your help.Johndba |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2002-05-07 : 06:52:15
|
| You might need to play around with the user permissions. You can prohibit users from inserting rows into tables and also restrict them from creating their own. |
 |
|
|
|
|
|
Restricting import possibilities