Create an account

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

First you need to create a login on the server level (in the security node) and map this to a user on the database level.

Then you assign this user to the db_datareader database role.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Sushant Yadav SSCrazy Points: 2780 More actions · Answer 2

Create new SQL Server Login and map that login to your required database.

After mapping you need to assign db_datareader role to user.