Re: Website, AD user -> ROLE -> sql Server question
From: Wei Ci Zhou (weicizhou_at_hotmail.com.discuss)
Date: 01/28/04
- Next message: Tibor Karaszi: "Re: Are SQL logins case sensitive"
- Previous message: Don Grover: "Re: Are SQL logins case sensitive"
- In reply to: sqlServerQuestion: "Website, AD user -> ROLE -> sql Server question"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 28 Jan 2004 13:12:05 +0800
Hi:
I doubt why you use the AD like this, before I made a intranet site
which ask user verify, I get the account in the IIS then I pass the user
name get from asp to database, when connect to database, I only use the sa
or other same account.
If you what to verify some account, you may verify in the system, do not
need verify in sql server, I think it is not necessary.
Best Wishes
Wei Ci Zhou
"sqlServerQuestion" <anonymous@discussions.microsoft.com> wrote in message
news:9EB740A4-BD72-4F6D-A842-AD4419A50B16@microsoft.com...
> Hello - users enter corporate intranet site and the application gets their
user name from AD. Then it needs to connect to Sql Server and pass
> (1) either a user name or
> (2)SQL server role name that user belongs to (if he does)
>
> This way only authorized users who've been added to the role will have
alter permissions on tables.
>
> Is this approach correct? How do I do this?
> Please help. Thank you.
- Next message: Tibor Karaszi: "Re: Are SQL logins case sensitive"
- Previous message: Don Grover: "Re: Are SQL logins case sensitive"
- In reply to: sqlServerQuestion: "Website, AD user -> ROLE -> sql Server question"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
