Re: LDAP security

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 10/31/03


Date: Fri, 31 Oct 2003 09:48:20 +0100

You can use sp_grantlogin to allow login to SQL Server to a complete Windows
group.

-- 
Dejan Sarka, SQL Server MVP
Please reply only to the newsgroups.
"Mike" <anonymous@discussions.microsoft.com> wrote in message
news:04b601c39f21$9d83bee0$a101280a@phx.gbl...
> Managing and supporting logins and passwords is a tedious
> task. My company uses LDAP security. Is there a way
> (hopefully simple) to pick in SQL Server 2000 users and
> related logins from an LDAP server?


Relevant Pages

  • Re: System Administrator Implied Permissions
    ... >> Hi Dan, ... >> Now, given this, why does SQL Server ... However, these logins were not ... Other sysadmin role members have the ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server 2005 Login Problem
    ... There are two authentication method in SQL Server. ... 1- Windows Authentication ... Only creating Logins is not the complete solution of course, then you'll need to map those users to the appropriate databases and assign them roles and grant them permissons. ...
    (microsoft.public.sqlserver.clients)
  • No Application Logins Allowed - SOX
    ... I'm trying to work through an issue regarding our MS SQL Server logins. ... "Customer" application uses a login to SQL Server called "Customer" and the ... Grant our users Windows Authentication access to SQL Server. ...
    (microsoft.public.sqlserver.security)
  • Re: Windows permissions to run Jet OLEDB 4.0
    ... in SQL Server or not when you have to go outside of the server to the ... Actually I was talking about Windows logins. ... There is no security whatsoever implemented on the mdb ...
    (microsoft.public.data.oledb)
  • Re: End User Security Administrator for a Intranet Application
    ... If you are on SQL Server 2000, ... server role can change passwords and add logins. ... >role 'sysadmin' inorder to create logins, ...
    (microsoft.public.sqlserver.security)