Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Express Edition and Compact Edition (2005)  HELP! Table Permissions (I think)

Author  Topic  quick503 Starting Member 1 Post Posted - 2009-09-10 : 12:42:25 I need some help quick. I have to present my website to the client this afternoon.IIS on 2000 Server on doc-serverSQL Server 2005 Express on doc-serverASP.NET 2.0Visual Web Developer 2005 Express on doc-serverI added a table to an existing SQL database. All tables in the database need read only (select)access except for tempQuery which needs Delete,Update, Insert and Select. When I run the website through Web Developer everything works great. However when I try to it through the internet or intranet (localhost) it works until I need to do something with tempQuery and then gives this error: Cannot find the object "tempQuery" because it does not exist or you do not have permissions. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Cannot find the object "tempQuery" because it does not exist or you do not have permissions.Source Error: Line 99: Dim cmd As New SqlCommand(strSQL, conn) Line 100: cmd.Connection.Open() Line 101: cmd.ExecuteNonQuery() Line 102: End Function Line 103: Public Shared Function GetSQLTQResults() As DataTable Line 101 is highlighted. I know I can read from the database because it gets past the login and that data is in the database. So it seems to be a permission problem.Am I correct in assuming that the user is IUSR_Doc-Server? I added that use to the domain and set permissions in the database but it still won't work.Any help would be greatly appreciated!