<div>
EXEC sp_change_users_login 'report' &nbsp;Returns no users<br />
<br />
I just tried the GRANT command again and it worked. The difference now is most users have gone home and the load on this old server is much lighter.
</div>


EXEC sp_change_users_login 'report'  Returns no users

I just tried the GRANT command again and it worked. The difference now is most users have gone home and the load on this old server is much lighter.

<div>
If they were in the system it'd probably block adjustments to their user permissions, because of active use. So that makes sense.
</div>


If they were in the system it'd probably block adjustments to their user permissions, because of active use. So that makes sense.

<div>
A more accurate message would have been helpful.
</div>


A more accurate message would have been helpful.

<div>
<div class="content wysiwyg-content">
I wanted to grant access to a table to a user so I exeuted this:<br />
GRANT SELECT,UPDATE,INSERT on [MyDB].[dbo].[MyTable] TO MyUser<br />
<br />
Which returned this message:<br />
Cannot find the user 'MyUser', because it does not exist or you do not have permission.<br />
<br />
I then ran this:<br />
EXEC sp_change_users_login @Action='update_one', @UserNamePattern='MyUser',<wbr /> &nbsp; &nbsp;@LoginName='MyUser';<br />
<br />
Which returned this:<br />
Terminating this procedure. The User name 'MyUser' is absent or invalid.<br />
<br />
I am logged in as 'sa' and 'MyUser' is a valid SQL user.<br />
<br />
I have checked other SQL users and they fail the same way.<br />
<br />
What is wrong here and do I fix this?
</div>
</div>


I wanted to grant access to a table to a user so I exeuted this:
GRANT SELECT,UPDATE,INSERT on [MyDB].[dbo].[MyTable] TO MyUser

Which returned this message:
Cannot find the user 'MyUser', because it does not exist or you do not have permission.

I then ran this:
EXEC sp_change_users_login @Action='update_one', @UserNamePattern='MyUser',    @LoginName='MyUser';

Which returned this:
Terminating this procedure. The User name 'MyUser' is absent or invalid.

I am logged in as 'sa' and 'MyUser' is a valid SQL user.

I have checked other SQL users and they fail the same way.

What is wrong here and do I fix this?

SQL claims users do not exist when they do.

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.