The xAssets API - Method : SpecialResetUser

Summary

Reset a users permissions. This will execute all sql grant commands needed for the user to have operational access to the sql server database.

Although rarely needed, there are situations where the users grants are lost by sql server, this restores the users account where a permission denied error message was raised.

Parameters

Parameter : sXML

Parameter : sArguments

0
UserID to reset permissions for

Returns

An empty string

Syntax and Examples

Restful syntax with Microsoft Visual Basic

Example 1 - Reset the user DEV\Administrator

There is no restful call for this API operation - use a SOAP method instead

SOAP Syntax with Microsoft Visual Basic

Example 1 - Reset the user DEV\Administrator


    Try

        ErrorMessage = ""

        Return w.WebSaveSpecial(_hash, _username, _db, _ip, "", "SpecialResetUser", {"DEV\Administrator"}, False, _dns, _port, _scheme, _nonce, _noncedate)

    Catch ex As Exception
        ErrorMessage = ex.Message
        Return "
    End Try

                            

AMSX Syntax

Example 1 - Reset the user DEV\Administrator


    SaveSpecial "SpecialResetUser","", "DEV\Administrator"
                        

XCS Syntax

Example 1 - Reset the user DEV\Administrator


    Dim ret as String = Server.SaveSpecial("SpecialResetUser","", "DEV\Administrator")
    If ret = " Or ret.Substring(0, 8) = "special=" Then
        MsgBox("Save operation completed.", vbInformation, "Save Data")
    Else
        MsgBox("Save operation failed:" & ret, vbExclamation, "Save Data")
    End If
                        

Download the Visual Studio API Samples Project

Return to the API Index Page