ASP.NET and MSDE

[antbates]

Hi all, I am trying to add a column to a table over ASP.NET using something like: "ALTER TABLE tblxxx ADD colyyy char(10)" However, it fails telling me that ASP.NET does not have the correct privaledges. I have been through "GRANT all ON tblxxx TO ASPNET" etc, but to no avail. Anybody know how to give ASPNET the correct access to add a column? Cheers.

[antbates]

All, OK, problem solved by creating a role with the appropriate access and using exec sp_addrolemember Cheers