aka “A Monty Python Approach to Security”… I found this oldie on my Laptop. The…
Category: Oracle
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 """ "
but there is no way to show the proper result on the Forum (even here I had to enable some tricks to show it…)
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