granting read access to databases in sql server 2000

hello sorry to ask 'youruser' in the sence username please correct if i am wrong

yes it is the username

thanks a lot Robbin it worked one small question is there any difference in public and datareader as the user was executed as datareader but he was provided with public through the script please suggest if possible.

The public role is a special database role to which every database user belongs. The public role captures all default permissions for users in a database. It cannot have users, groups, or roles assigned to it because they belong to the role by default. It is contained in every database, including master, msdb, tempdb, model, and all user databases.

Thanks Robbin once again for your detailed clarification.