Just to be sure I didn't have an orphaned login, I ran sp_change_users_login 'report' and got zero results

I ran select * from sys.database_permissions and got the results below (not all rows, the rest have negative numbers for the major_id, they are system objects) . They are the same on the database that the user can login and the one that he cannot

How do these results verify if a specific login can log in or that the database user was created correcty? I looked here - http://msdn.microsoft.com/en-us/library/ms188367.aspx - but don't see the connection.

Thanks

Dave

classclass_descmajor_idminor_idgrantee_principal_idgrantor_principal_idtypepermission_namestatestate_desc

0DATABASE0011CO CONNECTGGRANT

0DATABASE0051CO CONNECTGGRANT

0DATABASE0061CO CONNECTGGRANT

0DATABASE0071CO CONNECTGGRANT

1OBJECT_OR_COLUMN-505001SL SELECTGGRANT

1OBJECT_OR_COLUMN-504001SL SELECTGGRANT

1OBJECT_OR_COLUMN-503001SL SELECTGGRANT

1OBJECT_OR_COLUMN-502001SL SELECTGGRANT