Monthly Archive: November 2008

Nov 19 2008

Security – The Weakest Link Factor

aka “A Monty Python Approach to Security”… I found this oldie on my Laptop. The presentation was once given by me to create more awareness for this “Security” issue, while dealing with Oracle software or creating software in general. I still have to laugh when I think about the time I presented it…and Yeah…”most” of …

Continue reading »

Nov 17 2008

HOWTO: Avoid Conversion of Escape Codes

Sometimes the OTN Forum site scrambles to much code. The answer given / demonstrated on this site here, was asked on the OTN Forum: "Problem using extract function (PL/SQL) with "&#34" " but there is no way to show the proper result on the Forum (even here I had to enable some tricks to show …

Continue reading »

Nov 13 2008

Security: Setting an “Impossible” Password for SYS

I am currently busy trying to lock down (secure wise) APEX, which is, to say the least, very hard… Anyway one of my tricks from the old days (the days you couldn’t lock an account / database schema), was to lock an user account via the following alternative use of the ALTER USER statement ALTER …

Continue reading »

Nov 10 2008

HOWTO: Validate XML data

Sometimes the “how to validate XML” question arises again on the OTN XMLDB Forum. A quick start would be to read up on the XMLDB FAQ Forum questions were Mark Drake demonstrates XML validation via some good examples. Another resource would be to read the Oracle XMLDB Developers Guide chapter about “Transforming and Validating XMLType …

Continue reading »

Nov 02 2008

Eat one Square Meal a Day

One of my favorite games continues shortly. Related posts: This is so Wrong – WiiWare for the Wii !