Here's a scenario
I connect to BE SQL server with large tables and to avoid continuous hits to the server and reduce network traffic and most importantly keep the network guys off my back, pull records that are accessed frequently down to temp tables in a locally held access BE (ACCDB) which is encrypted. I read the latest encryption used by Access is a very respectable not so easy to break 256-bit symmetric key. The password is so long and complicated not even I can remember it. in fact I have to write it down and keep it under lock and key in a deep and dark place so no-one can find it. I know all the experts say you shouldn't write passwords down because it defeats the purpose or its a vulnerability, so perhaps maybe someday I would have sprinkled it with Worcester sauce, chewed it up and swallow it never to used again.
Now I can sleep in peace, rested in the knowledge that even the great Edward Snowden can't nick my data and i wont be at the centre or even at the peripheries of a Guardian style report, hounded by former paymasters or mocked by competitors.
Then today I wake up and decide to take a peek in the front end MySysObjects table. Why did I do that when I was already at peace, I'll never know. Was because there's my key in plan text for all to see, written down courtesy of makers of the encryption. Well done guys, nice job.
Why have such a well encrypted file? Is it for therapeutic purposes or just to give me false sense of security and make me 'feel' the data was secure from thievery?
Perhaps I misunderstood the point of encryption and secure passwords? why was I so paranoid about writing it down when I should have in fact plastered it all over the main screen. Someone please tell me I'm just being silly, take me from my dystopia and return me back to my utopia.
Please
I connect to BE SQL server with large tables and to avoid continuous hits to the server and reduce network traffic and most importantly keep the network guys off my back, pull records that are accessed frequently down to temp tables in a locally held access BE (ACCDB) which is encrypted. I read the latest encryption used by Access is a very respectable not so easy to break 256-bit symmetric key. The password is so long and complicated not even I can remember it. in fact I have to write it down and keep it under lock and key in a deep and dark place so no-one can find it. I know all the experts say you shouldn't write passwords down because it defeats the purpose or its a vulnerability, so perhaps maybe someday I would have sprinkled it with Worcester sauce, chewed it up and swallow it never to used again.
Now I can sleep in peace, rested in the knowledge that even the great Edward Snowden can't nick my data and i wont be at the centre or even at the peripheries of a Guardian style report, hounded by former paymasters or mocked by competitors.
Then today I wake up and decide to take a peek in the front end MySysObjects table. Why did I do that when I was already at peace, I'll never know. Was because there's my key in plan text for all to see, written down courtesy of makers of the encryption. Well done guys, nice job.
Why have such a well encrypted file? Is it for therapeutic purposes or just to give me false sense of security and make me 'feel' the data was secure from thievery?
Perhaps I misunderstood the point of encryption and secure passwords? why was I so paranoid about writing it down when I should have in fact plastered it all over the main screen. Someone please tell me I'm just being silly, take me from my dystopia and return me back to my utopia.
Please