{"id":402,"date":"2011-09-01T00:00:39","date_gmt":"2011-09-01T00:00:39","guid":{"rendered":"http:\/\/reservoirsw.com\/?p=402"},"modified":"2024-01-06T16:55:31","modified_gmt":"2024-01-06T16:55:31","slug":"sep-2011","status":"publish","type":"post","link":"https:\/\/snessug.craftydba.com\/?p=402","title":{"rendered":"Sep-2011 ~ How to audit and prevent unwanted user actions ~ John Miner"},"content":{"rendered":"<p><a href=\"https:\/\/snessug.craftydba.com\/wp-content\/uploads\/2012\/03\/fall-leaves-th.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/snessug.craftydba.com\/wp-content\/uploads\/2012\/03\/fall-leaves-th.jpg\" alt=\"\" title=\"fall\" width=\"125\" height=\"124\" class=\"alignleft size-full wp-image-108\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #800000;\">Presenter:<\/span>  John Miner of Sensata Technologies<br \/>\n<span style=\"color: #800000;\">Topic:<\/span> How to audit and prevent unwanted user actions<\/p>\n<p>&nbsp;<\/p>\n<p>Many corporations are composed of small divisions located in countries throughout the world. While you might be the lead DBA for your corporation, there are several other employees who have the keys to the kingdom. How do you prevent and audit unwanted user actions to key data? <\/p>\n<p>This presentation will review techniques on how to prevent and\/or audit data and schema changes. <\/p>\n<p>The following topics will be presented with examples. <\/p>\n<p>1. Granting correct user access is vital<br \/>\n2. Using DML triggers to keep an DATA audit trail.<br \/>\n3. Using DDL triggers to keep an SCHEMA audit trail.<br \/>\n4. Preventing unwanted DATA modifications<br \/>\n5. Preventing unwanted SCHEMA changes<br \/>\n6. Preventing table TRUNCATIONS<br \/>\n7. New Feature in 2008 &#8211; change data capture <\/p>\n<p><span style=\"color: #800000;\">Biography:<\/span><\/p>\n<p>John Miner (www.craftydba.com) has twenty years of data processing and proven project management experience, specializing in the banking, health care, and government areas. His architecture expertise encompasses all phases of the project life cycle, including design, development, implementation, and maintenance. His credentials include a Masters degree in Computer Science from the University of Rhode Island with concentrations in database technologies and programming languages. He has Microsoft Certificates for Database Administration (MCDBA) and System Administration (MCSA). <\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Presenter: John Miner of Sensata Technologies Topic: How to audit and prevent unwanted user actions &nbsp; Many corporations are composed of small divisions located in countries throughout the world. While you might be the lead DBA for your corporation, there are several other employees who have the keys to the kingdom. How do you [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[187],"tags":[91,6,89,20,90,92,44,12],"class_list":["post-402","post","type-post","status-publish","format-standard","hentry","category-2011-events","tag-change-data-capture","tag-dba","tag-ddl-triggers","tag-developer","tag-dml-triggers","tag-permissions","tag-security","tag-sql-server"],"_links":{"self":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/402","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=402"}],"version-history":[{"count":9,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/402\/revisions"}],"predecessor-version":[{"id":1160,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/402\/revisions\/1160"}],"wp:attachment":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=402"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=402"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=402"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}