How check user name?

26 Aug 2005 8:54 AM

Oleg Cherkasenko

I have COM object working with database via connection with administrative
rights.
I need method for checking user name: can this user has db access or no.

I want to check:

1. SQL Server users
2. Windows users which added as a SQL Server logins/db users
3. Windows users which can connect to db as a members of windows groups
added to SQL Server.

Thnx.

26 Aug 2005 10:00 AM

mark baekdal

have you looked into using SQL-DMO. The object model has collections and
methods to do all you ask.

regards,
Mark Baekdal
MSN m_baek***@hotmail.com
+44 (0)141 416 1490
+44 (0)208 241 1762
http://www.dbghost.com
http://www.innovartis.co.uk
Build, Comparison and Synchronization from Source Control = Database change
management for SQL Server

Show quote

"Oleg Cherkasenko" wrote:

> I have COM object working with database via connection with administrative
> rights.
> I need method for checking user name: can this user has db access or no.
>
> I want to check:
>
> 1. SQL Server users
> 2. Windows users which added as a SQL Server logins/db users
> 3. Windows users which can connect to db as a members of windows groups
> added to SQL Server.
>
> Thnx.
>
>
>