Results 1 to 2 of 2

Thread: SQL Security

  1. #1
    Join Date
    Sep 2012
    Posts
    1

    Unanswered: SQL Security

    We have a SQL database that uses Active Directory with Windows Authentication. Can users that are members of the Active Directory group that has read/write access to the SQL database create ODBC connections to access the database directly and update the data? They don’t have individual logins on the server. They are only members of the Active Directory group that has a login? Thanks for your help.

  2. #2
    Join Date
    Aug 2008
    Posts
    147
    Yes , they can. For example if you have SQLSERVER1 and the AD group "mygroup" with a member "Member1" - , and the AD group had a Logon with read\write on a database.

    "Member1" could create an ODBC - logon and make the changes. This also applies to any other members of the AD group "mygroup"
    I'm assuming you haven't got some other security restriction
    ---------------------------------
    www.sqlserver-dba.com
    www.dba-db2.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •