Last post Aug 12, 2008 12:02 PM by MehrdadAfshari
Aug 12, 2008 09:15 AM|lakku|LINK
i have created a table in sql server 2005
and i created a connection in web application using vb.net
but it is displaying error as
"The SELECT permission was denied on the object 'employee', database 'employee', schema 'dbo'."
i also checked database role membership details for my database which is under user mappiny in sql server
also it is not working
plz tell me the solution
Aug 12, 2008 12:02 PM|MehrdadAfshari|LINK
The user account your Web application is using to connect to the database does not have the SELECT permission on the employees table.
You can resolve the problem by adding the user you're connecting with (look at your connection string) to db_owner role of the database.
If you're using integrated security, ASP.NET uses "Network Service" account by default in Win2003 onwards (on <= XP it's ASPNET account). You can add it to db_owner role of your database to get rid of the problem.