> My concern is : to get my pwd : GET_MYPWD(CURRENT_USER) .
> Is it possible ?
>
> Adomas

there is nothing stopping you from getting the encrypted password back from
the security database.
You will need to decrypt it.
Brute force? or as you suggest encrypt your known password and check for a
match.
Alan