Month: November 2008

November 19
November 17

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 it…)

Read the Post HOWTO: Avoid Conversion of Escape Codes

November 13

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 USER {username} IDENTIFIED BY VALUES ' {String} '

of course nowadays you can use the more complete syntax

ALTER USER {username} IDENTIFIED BY VALUES ' {String} ' ACCOUNT LOCK

Most of the time this method is used to reset the password to its original value.

I noticed in my (secured) Oracle 11g EE database version that passwords are not shown anymore via DBA_USERS

Read the Post Security: Setting an “Impossible” Password for SYS