Differences

This shows you the differences between two versions of the page.

--- rb-projects-access:start [21/02/2025 13:23] – andrew
+++ rb-projects-access:start [18/09/2025 16:44] (current) – [SQL examples] andrew
@@ Line 6: / Line 6: @@
 Key cards with a serial number are issued and each door has a Wiegand or rfid style reader, optionally requiring a PIN as well as card to unlock. Maybe bluetooth instead of PIN?
-Also, by abstracting the keypad / reader and lock from the physical device, it should enable MQTT enabled devices to be included. If they are to be trusted..... So PKI is probably needed to maintain trust and security. (Trust but Verify!)
+Also, by abstracting the keypad / reader and lock from the physical device, it should enable MQTT enabled devices to be included. If they are to be trusted..... So PKI is probably needed to maintain trust and security.  [[https://en.wikipedia.org/wiki/Trust,_but_verify| (Trust but Verify!) ]]
 [[https://dbdiagram.io/d]]
+[[https://www.usmartcards.co.uk/Access-control]]
 ===== Flow =====
@@ Line 51: / Line 52: @@
 </code>
 so card number 1234 is cardID 1 and  userID 3.
-presented to reader 7678 which is doorID 3 back door, as it is external it requires a PIN as well
+presented to reader 7678 which is doorID 3 back door, as it is external it requires a PIN as well. But
-userID 3 has access level to doorID "3" of "denied".
+as userID 3 has access level to doorID "3" of "denied", no access is granted even if a valid card and PIN is presented.
@@ Line 191: / Line 192: @@
 [[rb-projects-access:sqlexamples|rb-projects-access:sqlexamples]]
+===== References =====
+[[https://www.linux.com/training-tutorials/simple-card-based-access-control/]]