| Author |
Messages |
|
Rob
 |
| 09/26/2001 8:24 AM |
 Quote
 Reply
 Alert
|
| I have NT groups and logins for these groups created in MS SQL (with Win NT authentication). For each login I have different roles. I need to know which role or group is set for CURRENT_USER.
Application is ASP, but I don't know how to get NT group name for current user in ASP. |
|
|
|
|
Chip Andrews
|
| 09/27/2001 9:22 AM |
Quote
Reply
Alert
|
| Check out the IS_MEMBER function.
Syntax
IS_MEMBER ( { 'group' | 'role' } )
Arguments
'group'
Is the name of the Windows NT group being checked; must be in the format Domain\Group. group is sysname.
'role'
Is the name of the SQL Server role being checked. role is sysname and can include the database fixed roles or user-defined roles but not server roles.
|
|
|
|
|
|
|
|
|
|
Quick Reply |
 |
|
|
|