in reply to How to change expired database password via DBI?

I am not sure if you could directly do so through DBI but you could certainly use sqlplus and then automate the password generation and changing via Expect. Granted this is not a pure perl solution but it works.
  • Comment on Re: How to change expired database password via DBI?

Replies are listed 'Best First'.
Re^2: How to change expired database password via DBI?
by Sue D. Nymme (Monk) on Aug 19, 2009 at 16:02 UTC

    There are a couple problems with that suggestion; One, sqlplus is Oracle, not SQL Server; two, many of our users do not have TOAD or Query Analyzer on their computers.

    But thanks for your suggestions.

[reply]

In Section Seekers of Perl Wisdom