ENCRYPT

[Napoleon99]

Hi,

I know there is way to encrypt values
in a column (for example passwords),
but I cannot find it anywhere in the
SQL help. Could anybody help me?

Thank You

 

[SQLSister]

Nope there is not. You have to encrypt on the client side and send the data already encryted.

 

[Napoleon99]

SQLSyster,

Thank you very much.
That probably why it isn't in the SQL help.
Thanks again.

P.S. I like your nickname

 

[litenin]

you could have a go with:
pwdencrypt(<password>)

it's undocumented so be a bit careful with it.

there's also a pwdcompare function which allows you to compare plain-text with the encrypted passwords which you can include in a job to check no users have obvious passwords, and shout at them if they do . Let me know if you want more details of this. I've got them at work.

Hope this helps

Dave