Giving windows account Read permission to an database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Giving windows account Read permission to an...

Giving windows account Read permission to an database

Rate Topic

Display Mode

Topic Options

Author

Message

balasach82

Posted Saturday, February 16, 2013 1:24 PM

Old Hand

Group: General Forum Members
Last Login: Monday, May 13, 2013 8:55 AM
Points: 307, Visits: 743

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

Post #1420923

IgorMi

Posted Saturday, February 16, 2013 1:59 PM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 9:56 AM
Points: 1,882, Visits: 1,459

Have you checked the User mappings of the Login for the user you gave db_datareader?

Post #1420928

balasach82

Posted Saturday, February 16, 2013 2:04 PM

Old Hand

Group: General Forum Members
Last Login: Monday, May 13, 2013 8:55 AM
Points: 307, Visits: 743

Yes, I did that. Iright click user, user mappings, clik on database, giving read access

Post #1420929

balasach82

Posted Sunday, February 17, 2013 8:51 AM

Old Hand

Group: General Forum Members
Last Login: Monday, May 13, 2013 8:55 AM
Points: 307, Visits: 743

Guys, any help to get over this would be great.

Post #1420987

Andre Ranieri

Posted Sunday, February 17, 2013 11:56 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 4:56 PM
Points: 277, Visits: 201

Have you had any luck with this yet?

exec sp_addrolemember 'db_datareader',YourLogin should do the trick.

Andre Ranieri

Post #1420999

« Prev Topic | Next Topic »

Permissions