Re: How get WIN NT/2000 users full name?

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 10/28/03


Date: Tue, 28 Oct 2003 09:45:09 -0700

Nothing directly built into SQL Server that I can think of.
One option would be to get the info from AD using ADSI. You
could populate a table with AD info if that's what your
after. You can find an example of this in the following
article:
HOW TO: Populate a SQL Server 2000 Database with Information
from Active Directory
http://support.microsoft.com/?id=319716

-Sue
 
On Tue, 28 Oct 2003 06:05:08 -0800, Valério
<valmeida@net.ms.gov.br> wrote:

>
> How can I get WIN NT/2000 users' full name using SQL. I
>know I have the logins, but I need the full names.
>Perhaps, create a table with login, full name.
>
> Thanks in advance.
> Valério



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: Logins & Permissions
    ... At server level, we use "Logins" to connect to a SQL Server Instance and perform server level jobs. ... "Users" are used and these users are mapped to Logins. ... I am using SQL Server 2005 on a Windows NT Network ...
    (microsoft.public.sqlserver.security)