Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
manikandan
Starting Member
35 Posts |
 Posted - 2002-11-26 : 23:04:11
|
| Hi Guys,We create NT local groups and add users into those groups. We have a login for each group in our SQL Server. And the permissions are set according to the role. In short, we are using NT authentication to access SQL Server.But i would like to find the NT local group of a user. Is it possible to find the same using Query Analyzer. I am not looking for is_member() function. My requirement is like this. If i pass NT user name to a proc or something like that, it should be able to tell me the NT group of the user. Is it possible to do through SQL functions in a Query Analyzer.Thanks for your help.cheersmanikandanCheersManikandan |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-11-26 : 23:48:46
|
| Try using xp_logininfo or sp_helpntgroup. If these don't do it you might have to call an api function such as NETUSERGETGROUPS. If you want to do this through sql server you can create a ole/com object that provides calls NETUSERGETGROUPS and then call it usingsp_OACreate and sp_OAMethod and other sp_OA* (OLE Automation Extended Stored Procedures). |
 |
|
|
|
|
|
Finding out the Windows NT Group of the user