Check User Permissions

  • I'm building an Access front end and would like to provide a means by which problems with a user's permissions can be identified such as if they're userId has been setup under a particular DB either explicity or via a NT Group, the roles that they've been assigned, etc.

    How would I go about getting that information in one fell swoop?

  • This was removed by the editor as SPAM

  • Private Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long

    Public Function getOperatorLogin() As String

    Dim lpBuff As String * 100

    Dim lngreturnValue As Long

    lngreturnValue = GetUserName(lpBuff, 100)

    getOperatorLogin = left(lpBuff, InStr(lpBuff, vbNullChar) - 1)

    End Function

    😛

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply