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.
An empty string
There is no restful call for this API operation - use a SOAP method instead
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
SaveSpecial "SpecialResetUser","", "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