By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,767 Members | 1,302 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,767 IT Pros & Developers. It's quick & easy.

Access PErmissions issue

P: n/a
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

Apr 23 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.