M
Mr.KisS
Hi,
In my aspx page i use a stocked procedure and in this
procedure, there is a SELECT query. And whene the aspx page
calls the procedure i get this exception :
System.Data.SqlClient.SqlException: SELECT permission
denied on object 'users', database 'wizou', schema 'dbo'.
So, i must give the authorisation to ASPNET to use SELECT
queries but, i'm on SQL 2005 and there isn't Enterprise
Manager. How to make it with SQLCMD?
Thanks all
In my aspx page i use a stocked procedure and in this
procedure, there is a SELECT query. And whene the aspx page
calls the procedure i get this exception :
System.Data.SqlClient.SqlException: SELECT permission
denied on object 'users', database 'wizou', schema 'dbo'.
So, i must give the authorisation to ASPNET to use SELECT
queries but, i'm on SQL 2005 and there isn't Enterprise
Manager. How to make it with SQLCMD?
Thanks all