Adding a new user login

[Kris]

In Ms SQL 2000, I want to be able to share my database with another user but
I only want them to be able to look at the database and not be able to
change anything.

Does anyone know how I go about doing this?

[Raghuraman]

Re: Adding a new user login

Just use sp_adduser from the desired db & use sp_addrolemembe r if necessary