I have created a user login and want to copy another users access rights to the user I have created. Is there perhaps a way that I can do this witout manually going and adding the user rights.
Script the object level permissions for the first user and then in the script replace the first user with the user tht you have created and run against the database. This should do for you.