dbTalk Databases Forums  

Access PErmissions issue

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss Access PErmissions issue in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
coosa
 
Posts: n/a

Default Access PErmissions issue - 04-23-2006 , 05:40 PM






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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.