Re: SQL/IIS/Active Directory
From: BJ Freeman (spam_blockbfree_at_free-man.com)
Date: 06/28/03
- Next message: BJ Freeman: "Re: **follow "login" activities**"
- Previous message: Pranav: "SQL/IIS/Active Directory"
- In reply to: Pranav: "SQL/IIS/Active Directory"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Sat, 28 Jun 2003 09:36:32 -0700
If you use TCP/IP then you are using SQL authentication only. You can create
SQL login and use them in the connect string.
the assign the login to the Stored procedures, View, Tables you wish them to
have access to.
Note: you can use pipes and TCP/IP so you have both modes to use.
"Pranav" <pranav.desai@eyt.com> wrote in message
news:148e01c33d6c$639705f0$a401280a@phx.gbl...
> Scenario: A Win2k service is running under a domain
> account. The domain account has permissions to SQL
> server. Domain authenticated users make web requests thru
> IE 6 & IIS 5. These requests are directed to the Win2k
> service which in turn accesses the SQL server data via
> OLEDB and returns results back to the user.
>
> Question: Is there a way to utilize object level
> permissions assigned to the individual users using SQL
> server roles in the above scenario or will it always use
> the win2k service account's permissions?
>
> Thanks
- Next message: BJ Freeman: "Re: **follow "login" activities**"
- Previous message: Pranav: "SQL/IIS/Active Directory"
- In reply to: Pranav: "SQL/IIS/Active Directory"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
