AL: Improve Database Security (A Masterclass in Access Security) with Colin Riddington скачать в хорошем качестве

AL: Improve Database Security (A Masterclass in Access Security) with Colin Riddington

Colin Riddington outlines some of the main steps that developers should take to improve security. Which you should use will depend on who or what you are trying to protect your apps against. Some of these steps will be familiar to all experienced developers but the session will focus on less well-known aspects that may be new to some of you. Nothing can be 100% secure. A capable and determined hacker can break any Access database given sufficient time and motivation. However, by erecting various barriers, it is certainly possible to make the process so difficult and time consuming that it isn’t normally worth attempting. Included is a discussion of some of the security weaknesses built-in to the Access database structure and one or more security challenges for you to test your hacking skills against. All required code is provided together with example apps demonstrating its use. Article and Download: Improve Security in Access Databases https://www.isladogs.co.uk/improve-se... ~~~ 0:08 introduction by Maria Barnes for Masterclass in Access Security 1:27 Colin Riddington 2:14 Improve Database Security cannot be 100% secure ways of making it difficult id-10-ts, meddlers, plagiarisers, hackers 4:30 Cyber Security 4:49 Passwords 6:25 Security Methods 6:55 Security Systems 7:17 Obfuscate, Confuse . . . And Depress 7:24 copy options 8:05 spoofs 8:42 clippy 8:59 Improve Security – Basic Steps 11:56 password long and strong 12:00 time it takes a hacker to brute force your password 13:55 – Backend (Basic Steps) 14:00 Maria Q about how applying passwords 14:38 hide, disable, display, allow, options, ribbon, password file-based systems, mission critical SQL Server back-end (or similar back-end tool) more secure 16:32 – Frontend (Basic Steps) ACCDE, ACCDR encyption password FE memorable for users VBA Project password 17:52 password in each of these cases username and password different security levels Active Directory 19:09 encryption, cypher methods SHA256 online tool helps you calculate hashes from strings. You can input UTF-8, UTF-16, Hex, Base64, or other encodings. It also supports HMAC. https://emn178.github.io/online-tools... 20:28 – Warning external applications 21:07 get into your database mitigate as much as possible 22:58 – VBE Function names, arguments code signing project, Trusted Publisher make certificates secure 25:16 Microsoft Management Console add certificate trusted publishers import, export 27:40 – Further Options certificate - commercial, self BE files Option Private Module registry taskbar encrypt using reversible 128-bit encryption e.g. RC4 31:14 Secure Your Database - BEFORE certificate navigation pane hide, unhide 36:53 dbHiddenObject 38:02 Options USysRibbons 39:36 – AFTER QAT 41:02 Q Neil: Why hide the Status Bar? 41:35 Access Security Challenges https://www.isladogs.co.uk/security-c... 43:39 Encrypt No Strings Database external access disconnected ADO recordset challenge: What is the BE password? What is the encryption key? 51:52 What else? 52:24 Links 52:35 Questions 53:11 Q Neil: How can you anticipate what other programmes are potential automation clients? Adrian: how do you check? 54:34 Q Oswaldo O: How do you enable/disable the Shift bypass? 55:36 forgot to oppen with shift-bypass 56:14 VBA procedure names 57:02 Form_Timer, CheckProcess, WMI 57:55 AUG site update https://accessusergroups.org 58:00 Meeting Calendar 59:57 November meeting Replacing VBScript with PowerShell with Maria Barnes and John Clark (VBScript code written by Bill Mosca) https://accessusergroups.org/calendar... 1:01:29 Access Europe – Ynte Jan Kuindersma – Using Power Automate with Office Apps (1h14m50) video    • AEU45: Using Power Automate with Office Ap...   1:02:49 final questions NEXT Access Lunchtime meeting Replacing VBScript with PowerShell with Maria Barnes and John Clark (VBScript code written by Bill Mosca) https://accessusergroups.org/calendar... join us! Access Lunchtime hosted by Maria Barnes https://accessusergroups.org/lunch/