Posted by coosa on 04/24/06 01:40

Dear all,

I have been always accessing my database using the intergrated ASPNET
account; by default in MS VS 2005, a web site with a solution would
take a random port by the asp.net development server such as
http://localhost:3346/some_domain/Default.aspx.
Using the other appraoch, a web site takes the default http port;
however, the logged in user would be at such case NT AUTHORITY\NETWORK
SERVICE.
First i experienced exceptions from MS SQL Server 2005 such as login
denied to NT AUTHORITY\NETWORK SERVICE.
I played around with the security options and it seems login problems
are gone but new problems occured such as:
{"SELECT permission denied on object SomeView', database
'SomeDataBase', schema 'dbo'."} whereby 'SomeView' is a view name
appliad in the Database 'SomeDataBase'.
When i tried to grant permission for that view, only 4 users were
listen on that view; namely: public, guest, ASPNET and the
network_user. network_user is arenamed user for NT AUTHORITY\NETWORK
SERVICE and i did grant that user the select permission to that view,
but alwasy get the same error.

I appreciate any kind of help

Best regards

• Next in forum: Re: SELECT * FROM "multiple_tables" WHERE "field_(in_those_tables)_have_the_same_paricular_value" ?
• Prev in forum: Re: SELECT * FROM "multiple_tables" WHERE "field_(in_those_tables)_have_the_same_paricular_value" ?
• Thread view: Access PErmissions issue

[Reply to this message]