We need to store like an audit of certain tables in a database, which will have very sensitive information. We need to log all the users that opened this certain table, if modified store this information that has been changed and by whom.
I was planning to have trigger on the table, and write to another separate history table, when users access open the table.
Restrict access to the tables via database security to only dba's. Create a separate user/users accounts for stored procedures. Add logging in the stored procedures.
Ideally, you should use Windows Security from start to finish but I constantly get overruled on using Integrated Security down to db layer so someone may know something that I don't ... actually it is because most domains have Authentication Delegation disabled on the Domain and it has to be setup to successful delegate credentials using kerberos. Sys admins don't like changing things, it seems when accounts have delegation enabled programmers can write malicious programs that act as other users just like pilot's have to go through metal detectors.
To accomplish the autocomplete feature into our website, I went through the whole process of setting up AjaxControlToolkit on my computer. I set up a ADD TAB on Visual WEb Developer 2008 Web Express. Added an item and selected this dll. Was able to create the ajax controls.
Now when I set up a new web site, ajax and non-ajax web sites, for some reason I am unable to access these controls. Do I need to add the reference to the ajaxcontroltooklit.dll reference to this new web site project? I can see all the controls but on the design page when I try to drag an icon over, it does not let me .
Hi all, I need help validating textBox whether the user input was a correct date format and not empty. I can use RequiredFieldValidator to make sure the textbox is not empty but how do I know is correct date format which support my database.thanks,