Error while selection... [modified]
-
Im getting this error "SELECT permission denied on object '_______', database 'name of database', owner 'dbo'." while connecting to database in SQL in asp.net help -- modified at 3:50 Tuesday 31st July, 2007
-
Im getting this error "SELECT permission denied on object '_______', database 'name of database', owner 'dbo'." while connecting to database in SQL in asp.net help -- modified at 3:50 Tuesday 31st July, 2007
Sounds like your DB is set up so the user you're logging in as doesn't have permission to do a SELECT.
Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
-
Sounds like your DB is set up so the user you're logging in as doesn't have permission to do a SELECT.
Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
Isn;t it the ASPNET user, not the logged on user? I recall having to grant permissions to the ASPNET user more than once.
-
Isn;t it the ASPNET user, not the logged on user? I recall having to grant permissions to the ASPNET user more than once.
I was thinking of the user within the database, not the ASPNET user on the system, but you're right, that could be an issue also.
Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )