Monthly Archives: June 2017

#quicktip #oracle #sqlcl logon.sql #PLSCOPE_SETTINGS and #PLSQL_WARNINGS

Quick Tip. My logon.sql file. I don’t want plscope_settings and plsql_warnings set when I’m in production; but if I’m in my test / dev / sandbox environments, then I do turn them on. This helps. Enjoy; this should be self … Continue reading

Posted in Database Stuff | Leave a comment

#GDPR – RIGHT TO ACCESS. Security is a feature #3 Right to Access Part 1 of 2

The GDPR Right to access can get a bit complicated as it covers a few things that provide some challenges for us. What is the purpose of the processing? Lets face it, we process data on people for a number … Continue reading

Posted in Database Stuff, GDPR, infosec, Security | Tagged | Leave a comment

#SQLDeveloper Unit Testing

I’ll get back to the GDPR series tomorrow. Can I get a show of hands, How many people do unit testing? I’ve been in a lot of shops where unit testing and code reviews have been passed up in the … Continue reading

Posted in Database Stuff | Leave a comment

#GDPR is coming Security is a feature #2 Data Masking

#GDPR is coming Security is a feature #2 Data Masking In the context of GDPR, data masking should be done so that the all the data attributes on a person should not be able to define that person. Most of … Continue reading

Posted in Database Stuff | Leave a comment

#GDPR is coming Security is a feature #1

Security is feature. Over the next few weeks, I’ll be looking how some of the issues on how GDPR will be impacting us as technical professionals. There are a lot of things that I find technically interesting in GDPR such … Continue reading

Posted in Database Stuff | Leave a comment