Reset the Microsoft SQL Server Logon Credentials

Reset the Microsoft SQL Server Logon Credentials.

Procedure

In SQL*Plus, type the following command to run a stored procedure that resets the database user name and password:

sp_change_users_login 'Update_one', 'username', 'password'