NT Group Membership from SQL Server 
Author Message
 NT Group Membership from SQL Server
Is there a function/stored proc where I can pass a user name (or ID) and an
NT group and have it return a value indicating whether that user is a member
of that NT group?  Something like:

exec sp_NTGroupMember 'Joe', 'Sales'

Thanks in advance for your help.

Rob



Sat, 20 Mar 2004 11:12:28 GMT
 NT Group Membership from SQL Server

    Look at:

sp_helprolemember
sp_helpsrvrolemember

    You can pipe the output of these SPs into a temporary table & check
against that.

--
Umachandar Jayachandran
SQL Resources at http://www.umachandar.com/resources.htm
( Please reply only to newsgroup. )



Sat, 20 Mar 2004 13:13:05 GMT
 NT Group Membership from SQL Server

Quote:

> Is there a function/stored proc where I can pass a user name (or ID) and an
> NT group and have it return a value indicating whether that user is a member
> of that NT group?  Something like:

> exec sp_NTGroupMember 'Joe', 'Sales'

> Thanks in advance for your help.

> Rob

Hi,

Try sp_helpntgroup
Also IS_MEMBER

Kevin -cs



Sat, 20 Mar 2004 18:48:14 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Query LDAP user group membership frmo SQL Server

2. Getting NT group membership from TSQL

3. NT Group Membership

4. NT Group membership enumeration.

5. NT Group membership enumeration.

6. Verifying NT Username and Group Membership

7. Calling NT Server Groups to SQL Server

8. Retrieving NT server group information within sql server 7.0

9. Remapping/Copying SQL Logins from NT Local Groups to Domain Global Groups

10. SQL 7 Group Security and Predefined NT Groups

11. ldap query to resolve group membership in AD

12. "OLAP Administrators" Group Membership


 
Powered by phpBB® Forum Software