Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

New table permissions

Status
Not open for further replies.

jcs1953

IS-IT--Management
Nov 28, 2007
53
US
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
 
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
 
Changed connection string from (local) to .\sqlexpress.
Changed IIS user to aspnet
All is well.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top