find what nt user group? 
Author Message
 find what nt user group?

How can i find what nt user group sql used for authentication.  Exp. user j_doe
belongs to nt group Users. Domain\Users have rights to sql and that is how j_doe
is gaining access.  Is there anyway I can findout for trans-sql that j_doe
belongs to domain\users???? I hope I am explaining the right. What NT group does
a user belong to that let them into sql?

Thanks
Dave Jones
MCDBA, MCSE+Internet



Mon, 02 Jun 2003 05:29:19 GMT
 find what nt user group?

I don't believe that information is avalable that way.
Since the user belongs to a group that is enumerated as a group that may
access the SQL Server he is allowed access at a certain level ... that you
could find out. But how that user got it ... I don't think so ... not
without some sort of extended stored procedure ... or command line tool.

-Lars


How can i find what nt user group sql used for authentication.  Exp. user
j_doe
belongs to nt group Users. Domain\Users have rights to sql and that is how
j_doe
is gaining access.  Is there anyway I can findout for trans-sql that j_doe
belongs to domain\users???? I hope I am explaining the right. What NT group
does
a user belong to that let them into sql?

Thanks
Dave Jones
MCDBA, MCSE+Internet



Mon, 02 Jun 2003 08:23:56 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Error 15401 - NT user or group not found

2. Cannot find information about nt user/group

3. NT Group Vs NT User

4. NT User vs NT Group

5. Copy permissions from user/group to different user/group

6. Informix User Group - Forum 2000 - A Two Day User Group Technical

7. The User Group News: South Florida Informix User Group meeting

8. How to find the members of a NT group from within SQL

9. How to find members of a NT group from SQL

10. Find windows group for a user

11. Find what Groups a User belongs to

12. Find what Group a user is assigned to.


 
Powered by phpBB® Forum Software