Wednesday, March 7, 2012

Block MS Office Connection

SQL Server 2000.
Is there a simple way to block MS Office connections to a SQL Server database?
Thanks,
TomEasy, dont give them a login to use.
"T Morris" <TMorris@.discussions.microsoft.com> wrote in message
news:1C16D499-3B03-4252-A474-042650A67385@.microsoft.com...
> SQL Server 2000.
> Is there a simple way to block MS Office connections to a SQL Server
> database?
>
> Thanks,
> Tom|||Yes, disable the network adapter.
The long answer is no. If the user has a valid SQL Server username/password
(or) their network identity or group has access to the server/database, then
there are many applications, including Office products, that can be used to
access the data in the database.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"T Morris" <TMorris@.discussions.microsoft.com> wrote in message
news:1C16D499-3B03-4252-A474-042650A67385@.microsoft.com...
> SQL Server 2000.
> Is there a simple way to block MS Office connections to a SQL Server
> database?
>
> Thanks,
> Tom|||Hi Tom
One option may be to use an Application Role for your own application and
only grant the privileges needed to access the tables to this role.
If you restrict access to be only by stored procedures and don't use dynamic
SQL then your users will only be able to execute these procedures and not
access the data directly regardless of the application they are using.
John
"T Morris" wrote:
> SQL Server 2000.
> Is there a simple way to block MS Office connections to a SQL Server database?
>
> Thanks,
> Tom

No comments:

Post a Comment