Re: audit tables, delete triggers and sql server authentication
From: Bob Barrows [MVP] (reb01501_at_NOyahoo.SPAMcom)
Date: 11/26/04
- Next message: Mark Schupp: "Re: Create html table"
- Previous message: Evertjan.: "Re: Count URLS in table?"
- In reply to: ecastillo: "audit tables, delete triggers and sql server authentication"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 26 Nov 2004 08:02:15 -0500
ecastillo wrote:
?
>
> (i'm hoping a built-in function exists that solves all my problems.)
>
No, there isn't. The SQL Server only knows the name that was used to log
into it. How could it possibly have knowledge of credentials that were not
passed to it? As I see it, you have two options:
1. Use Windows Authentication and deal with te issues that arise from that
choice.
2. Do all data updates via stored procedures to which you pass the users'
Windows credentials.
I prefer option 2, since I prefer to do everything by stored procedure
anyways, meaning tat I started writing the app using them. I can understand
why you would hesitate to use this option if you've already got the app
written using dynamic sql (ugh!).
Bob Barrows
-- Microsoft MVP - ASP/ASP.NET Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM"
- Next message: Mark Schupp: "Re: Create html table"
- Previous message: Evertjan.: "Re: Count URLS in table?"
- In reply to: ecastillo: "audit tables, delete triggers and sql server authentication"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
