Get associated NT group.

[Nordlund]

Hi.
I want to find out what NTgroup i'm logging on with.

For example: I'm logging in to "MyDomain" with the user "MyUser". MyUser is a member of "MyGroup".

In the SQL Server, the group MyGroup has access to a database, the user has no explicit rights to the database.

SYSTEM_USER will now give me MyDomain\MyUSer, but I want to resolve the acutal group instead...

Is there a way to solve this, or am I stuck with my beard in the mailbox?



//Nordlund

 

[Nordlund]

Forgot a thing... The system: SQL Server 2000.

//Nordlund

 

[Nordlund]

Hi again.
Forget this thread. I realized it cannot be done in a proper way.

-- End thread --

//Nordlund