3

I am trying to grant rights to an Active Directory Group on a Linked Server. I am unable to do it; it only allows me to grant rights to individual active directory users. Does anyone know how to achieve this?

1 Answer 1

1

You can do by creating a role for the AD Group user and assigning permissions to it.

  1. Create your Active Directory Group as a login in SQL Server as below :

    USE master;
    GO
    CREATE LOGIN [COMPANYDOMAIN\ADGroup] FROM WINDOWS;
    GO
    
  2. Then create a user from the login in the database

    USE DatabaseName;
    GO
    CREATE USER [COMPANYDOMAIN\ADGroup] FROM LOGIN [COMPANYDOMAIN\ADGroup];
    GO
    
  3. Now Grant appropriate permissions to the user

    Note: Granting a server permission to a database role is not possible

    GRANT EXECUTE ON SYS.XP_PROP_OLEDB_PROVIDER to [COMPANYDOMAIN\ADGroup];
    
1
  • Doesn't this grant permissions to see the available linked servers, rather than grant permissions to use a specific linked server? Commented Aug 29, 2018 at 18:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.