SQL Log Shipping Read Only/Standby Different users
This can easily be achieved if you disable the login on the primary:


Add the login on the primary
Add the user to the database and grant permissions
Copy the login to the secondary
Disable the login on the primary