Derek
getting the logged on user name in TSQL is simply Current_User
then you could use something like:-
DECLARE @UserName varchar(100)
SET @UserName = Current_User
SELECT DbRole.Name
FROM sysusers AS DbRole
INNER JOIN sysmembers AS DbMembers ON DbRole.Uid = DbMembers.Groupuid
INNER JOIN sysusers AS DbUser ON DbMembers.MemberUid = DbUser.Uid
WHERE DbUser.Name = @UserName
and DbRole.issqlrole = 1
that will give you the list of Roles that this user belongs to.
Regards, Stuart
"Derek Hart" <dmh...@gte.net> wrote in message
news:O8zeIQyvBHA.2128@tkmsftngp07...
Derek
"Stuart Kirk" <in...@sks.demon.co.uk> wrote in message
news:#o$rC2IwBHA.2412@tkmsftngp04...