how do I create an sqlserver account that has the capability to only run reports and extract data?

how do I create a sqlserver account that has the capability to only run reports and extract data? The user will be connecting via SQLserver Mgt Studio thru our public IP. They really only need access to 2 database(s) to extract data and run reports against. Please advise
LVL 1
ID10TzAsked:
Who is Participating?
 
Simone BConnect With a Mentor Senior E-Commerce AnalystCommented:
You can give them datareader access to specific databases.

capture
0
 
ID10TzAuthor Commented:
and that doesnt allow them to change data right?
0
 
Simone BSenior E-Commerce AnalystCommented:
That's correct. It provides read-only access to the database. We use it primarily for report writers, who need data access, but don't need to insert, select, update, delete, etc.
0
 
ID10TzAuthor Commented:
exactly as I needed it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.