New table permissions

[jcs1953]

In testing my website I found that I needed to add a few tables to the database. The website was designed using ASP.Net 2. Internet and intranet access (IIS 6) worked fine before and works now except when I need to access the new tables. Then I get the "can't find or you dont have permissions" error. The website works fine when accessed through Visual Web Developer 2005 Express. So ...

1. What user is used when authentication through the internet and the intranet?

2. If I set permissions on the database why doesn't it apply to the new tables?

Any help would be great.

Thanks

 

[mrdenny]

1. That would be what ever user you specify in the connection string.

2. Unless you grant rights to query all objects in the database (which you probably didn't) you have to grant rights to each new object when it is created.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[jcs1953]

Changed connection string from (local) to .\sqlexpress.
Changed IIS user to aspnet
All is well.