February 16, 2013 at 1:24 pm
I have an user for whom read access has to be given to number of dbs.
I gave db_datareader to that user in 1 db A. But, he got access to view tables, and run create/drop statements in db B too. I am flummoxed by this. What should i do give an users windows account read access to db
in sql 2005, 2008,2008r2
February 16, 2013 at 1:59 pm
Have you checked the User mappings of the Login for the user you gave db_datareader?
Igor Micev,My blog: www.igormicev.com
February 16, 2013 at 2:04 pm
Yes, I did that. Iright click user, user mappings, clik on database, giving read access
February 17, 2013 at 8:51 am
Guys, any help to get over this would be great.
February 17, 2013 at 11:56 am
Have you had any luck with this yet?
exec sp_addrolemember 'db_datareader',YourLogin should do the trick.
Andre Ranieri
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply