Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
add comment

1 Answer 1

up vote 1 down vote accepted

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];
    
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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