In my last blog post I mentioned that I’ll write a new one on how to generate DDLs to recreate existing lockdown profiles – the time has come :).
Continue reading “How to generate DDLs of existing lockdown profiles”Lockdown profiles definition – NUL character
Playing more with lockdown profiles, I have discovered another interesting bit. For some entries and some columns of CDB/DBA_LOCKDOWN_PROFILES views (which are based on LOCKDOWN_PROF$ table), there is unnecessary NUL (ASCII code 0) character added at the end. In our environment it was the case for all OPTION$ (CLAUSE_OPTION column of the views) and only some of CLAUSE columns (the same name as in the views).
Change is the only constant... 