Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-16 : 09:30:13
|
| Jeannie writes "Hello,My question relates to security and permissions. I have a web application that needs to connect to a database via the IUser_account (anonymous user). I can connect to the database using an account I setup specifically for that purpose - but the problem I've run into is that I also want to restrict access to the database based on an NT Group. For example - I want to limit functionality to the 'ALLMangagers' NT group, yet because this application will need to access many servers/databases I don't want to create permissions for each user on all servers/databases - and basically I only want them to have access via an application role because they should not have access outside of the web application. I know I can restrict access to the web application itself via NT Authentication - but would prefer to do it within SQL Server if possible. Is there any way to accomplish this? Thanks in advance for you help!~JeannieSQL Server 7.0 or 2000 Windows 2000 - up-to-date service packs" |
|
|
|
|
|
permissions/ db access