hi,
Before I upgrade my window server from window 2000 server to window 2003 server (+sp3) I used to run my website and be able to view records from any table and execute any cmd shell code from aspx page. However, After the upgrade, I wasnot able to do any of the above unless, I assign permission in every single table with (insert, add, delete, etc)So I had to do that for every table.
But I have some store procedure that uses cmdshell, so when I called this store procedure , but the above error, I wonder
1) how I can provide permission to a web user to once click on a button from aspx page to exectute the cmdshel
2) is there a better way to access my data without giving permission to each single table, store procedure to a webuser.
The previous set up before update was fine and I was easier to manage.
please help
thanks
ehx
Before I upgrade my window server from window 2000 server to window 2003 server (+sp3) I used to run my website and be able to view records from any table and execute any cmd shell code from aspx page. However, After the upgrade, I wasnot able to do any of the above unless, I assign permission in every single table with (insert, add, delete, etc)So I had to do that for every table.
But I have some store procedure that uses cmdshell, so when I called this store procedure , but the above error, I wonder
1) how I can provide permission to a web user to once click on a button from aspx page to exectute the cmdshel
2) is there a better way to access my data without giving permission to each single table, store procedure to a webuser.
The previous set up before update was fine and I was easier to manage.
please help
thanks
ehx