how to create a new login to use only select query for that login?

Posted by Prabu_Spark under Sql Server on 12/10/2012 | Points: 10 | Views : 1057 | Status : [Member] | Replies : 4
Hi sir,
Tell me the steps to create a new login, that allows the user to enter only the select query, and dont have permission to delete or update the data in sql server database.

With regards,
J.Prabu.
[Email:prbspark@gmail.com]



Responses

Posted by: Saratvaddilli on: 12/11/2012 [Member] [MVP] Bronze | Points: 25

Up
0
Down
exec sp_addrolemember 'db_datareader',YourLogin

once go through this links

http://serverfault.com/questions/116267/how-can-i-create-a-read-only-sql-server-2008-account
http://msdn.microsoft.com/en-us/library/ms188629(SQL.90).aspx

Thanks and Regards
V.SaratChand
Show difficulties that how difficult you are

Prabu_Spark, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ranjeet_8 on: 12/11/2012 [Member] [MVP] Gold | Points: 25
Posted by: Pavanandey on: 12/11/2012 [Member] Bronze | Points: 25

Up
0
Down
@Ranjeet_8

Where do i need to specfiy the user name to whom i need to revoke persmissions

Thanks
Pavan Kumar
Mark Answer if this fits the need

Prabu_Spark, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sandhyab on: 12/12/2012 [Member] Starter | Points: 25

Login to post response