Alan McDonald wrote:

>
>
>>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.
>
>

How to do it ? , I will repeat : I am logged in remotely, via alias,
dont know where is security.fdb. I am logged in as sysdba. How can I
exctract my pwd insql SP ?

>You will need to decrypt it.
>Brute force? or as you suggest encrypt your known password and check for a
>match.
>
>

IF (DBPWD = ENCRYPT(MYPWD)) THEN .....

>Alan
>
>
>