Help Help How Can I get NT Group Name

Help Help How Can I get NT Group Name

Post by Kenny Cheun » Fri, 18 Jun 1999 04:00:00



Hello all Expert,
We use WIN NT Local Group to authorized our SQL 7.0,
I can get user name from users(),
how can I get the NT Group Name (function or stored procedure ? )

Thanks
Best Regards
Kenny

 
 
 

Help Help How Can I get NT Group Name

Post by Ralf Dietric » Fri, 25 Jun 1999 04:00:00


You should use > suser_sname() < and you will get the NT-Username -- I think
it's better than the NT-Group
Ralf


Quote:> Hello all Expert,
> We use WIN NT Local Group to authorized our SQL 7.0,
> I can get user name from users(),
> how can I get the NT Group Name (function or stored procedure ? )

> Thanks
> Best Regards
> Kenny