Greetings,

how to build a GRANT CONNECT TO "user" IDENTIFIED BY ENCRYPTED... statement
from sysuserperm view password column? SA 11.0.1

It was possible in ASA 9, it no longer works in SA 11, is there a way?

Thanks in advance,
Pavel

Pavel,

AFAIK this should work in SA 11.0.1, too - however the underlying hash
has changed.

As this syntax is typically used during an unload, I would try to do an
unload -n with a reload.sql to see what the encrypted byte string looks
like. (It could be different for old passwords from pre-10 databases and
new ones.)

HTH
Volker

Pavel Karady wrote: