I would think you might be able to do this using the Syslogins table
(not recommended though). Also, if the user has the permission coz of a
Windows NT group, then it becomes really difficult to check this with in
SQL Server.

John

-----Original Message-----
From: Kaze [mailto:[Email Address Removed]
Sent: Monday, July 28, 2003 9:15 AM
To: LazyDBA.com Discussion
Subject: RE: Checking for Valid NT User in SQL Server

Hi Chris,

There is an application in house that builds a user name that is entered
by a admininstrative user of the application. There is a job in SQL
Server that will give grant DB rights to the user. The job fails when
the user is not a valid NT user. The problem really is in the
application...they need to check if the user is valid or not. I'm just
wondering if it's possible for SQL Server to check this. Anyone?

Kaze

"Lepingwell, Christopher" <Christopher.[Email Address Removed] wrote:
Define valid. If they can connect to SQLserver they are by definition
valid.

-----Original Message-----
From: Kaze [mailto:[Email Address Removed] 28 July 2003 16:55
To: LazyDBA.com Discussion
Subject: Checking for Valid NT User in SQL Server



Hi all,

Is there anyway of checking if a user is a valid NT or Windows 2000 user
from SQL Server?

Thanks!

Kaze


---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software


---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
MS Sql Server LazyDBA home page