SQL2K - Linked server - Mapping Windows group to a remote login

From: VUILLERMET Jacques (jvuillermet_at_no-spam.fr)
Date: 07/02/03 

Date: Wed, 2 Jul 2003 20:01:09 +0200

My application uses an NT authentification login via a Windows group, as
recommended by Microsoft.
I've a linked server (Oracle), the link works fine.

I want to map the Windows group with one Oracle login (in Linked server
properties).

But, the combo box shows only the windows users and the SQL Server logins.

How to do ?

Jacques.

Relevant Pages

  • Re: SQL2K - Linked server - Mapping Windows group to a remote login
    ... > My application uses an NT authentification login via a Windows group, ... > I've a linked server, ... > I want to map the Windows group with one Oracle login (in Linked server ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Local Account Permission - Read Only on System Tables and
    ... Create a Windows group on the domain and have your developer logins added to ... VIEW SERVER STATE to that one login. ... can create your own server-level roles) and grant it VIEW SERVER STATE ...
    (microsoft.public.sqlserver.security)
  • Re: Is_Member problem : Does user belong to custom Group
    ... In active directory: 1 - Created in Active directory a Windows group named ... 'MyDomainName/MyApplReadOnly' as Login Name and the same as User ... We can create a ROLE in the database and add the users. ...
    (microsoft.public.sqlserver.security)
  • Re: deny select on linked server
    ... Here is a way to disable one login from using the linked server, while allowing all other logins through. ... -- Grant the excluded login rights to login with a non-existing login and password ... In the radio buttons below, select "Be made using the login's current security context" ...
    (microsoft.public.sqlserver.security)
  • Re: Is_Member problem : Does user belong to custom Group
    ... - Added in Security/Logins the windows Group 'MyDomainName/MyApplReadOnly' referred as type 'Windows Group' with Defaultdatabase 'Master' ... Then configured the database Role Membership of this user by setting db_datareader and db_denydatawriter to true. ... for the current user returns 0 although he is referred in active directory as someone belonging to the the windows group Mydomainname\MyapplReadOnly ... There is a login, there is a user that mapped to the Login ...
    (microsoft.public.sqlserver.security)