change login to select only

Question

I want to have my login to my database to enable users to select data only. 

How can I do this in management studio ?

Answer 1

below thread should address this issue

http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/3e907fe4-b7e1-46c1-81bf-e01c9c5c088b/

---

Regards,
Ahmed Ibrahim
SQL Server Setup Team
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.

Answer 2

could you please check the provided link here may help you.

http://www.ehow.com/how_6518949_change-logon-username-domain.html

Answer 3

Hello David_Steiner,

The thread http://social.msdn.microsoft.com/Forums/en-US/Msdnmod/thread/66f47156-aae9-4cd6-8f31-55bc75fbb364/ is about this problem ( available only for the moderators )

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.