Hi Matt,

If I understand your requirement correctly, you need to create a SQL login that is based on an NT group or an NT user. On the target database, you create a new user that maps to the previously created login. Now, you can grant permissions against that user.

HTH