Getting error while connecting to database using entity framework

Question

I have created a database MVCLearn with table general information

I want to display details in view with the help of Id, I used entity framework for data retrieving from database

so if i use id in url i will get the particular details of that person.

but when i run, browser is displaying an error this way

The error message is self-explanatory - the account you are connecting to the database with doesn't have permissions to do select queries on the db/table — user1666620
– user1666620, Commented Jun 7, 2016 at 15:17
Seems like an obvious error, the user context in the connection string you are using to connect to the database has no read/select permissions. So what is your question? — Igor
– Igor, Commented Jun 7, 2016 at 15:18
For retrieving data from database do we need to grant permissions for database so that we can use that data in project? If so how? — Anish varma Adduri
– Anish varma Adduri, Commented Jun 7, 2016 at 15:20

Rico Herlt · Accepted Answer · 2016-06-07 15:32:27Z

1

yes you need to grant at least read only permissions to your login which is used to access the database. Here you can find a good tutorial with pictures from Joel Lipman where all of these permissions are described: Create Read-Only Database User in SQL Server

I hope this helps.

answered Jun 7, 2016 at 15:32

Rico Herlt

1368 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Peter Smith · Accepted Answer · 2016-06-07 15:34:45Z

1

You need to create/modify a user on the SQL server that has the required permissions on that server.

Use the User Mapping option. Then setup that user for EF

answered Jun 7, 2016 at 15:34

Peter Smith

5,5529 gold badges54 silver badges80 bronze badges

1 Comment

Anish varma Adduri Over a year ago

your Suggestion Worked

abrown · Accepted Answer · 2016-06-07 15:35:42Z

0

As the comments suggested, you need to grant permissions to your user to select data from the table. You can do this for a specific table like this:

grant select on dbo.tblEmployee to [YourUser]

However, it is more likely that you would want to add your user to a role, for selecting data only, you can use the following:

ALTER ROLE db_datareader ADD MEMBER [YourUser]

Hope this helps.

answered Jun 7, 2016 at 15:35

abrown

7156 silver badges17 bronze badges

Collectives™ on Stack Overflow

Getting error while connecting to database using entity framework

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related