question

Roshan12291 avatar image
Roshan12291 asked

restrict the access of the user if he is accessing the SQL server from Microsoft office

I have one scenario that I want to restrict the access of the user if he is accessing the SQL server from Microsoft office how to do it pls suggest some scripts it urgent..
sql-server-2008sqlsql server 2012dba-developer
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
anthony.green avatar image
anthony.green answered
Take a look at logon triggers where you can rollback the login if the application name is like Microsoft Office [Logon Triggers][1] [1]: https://docs.microsoft.com/en-us/sql/relational-databases/triggers/logon-triggers
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.