change user

[Hicham BOUZDAD]

Hello everybody,

can i change a user  in a perl script using DBI.
I explain :
I want to do :

$dbh = connect(....'user1',....)
....
change_user_to ( 'user2' );        ###########   like in Postgresql
commande :        "  \c - user2 "
$dbh -> do ('...');


this is because i want to have only ONE dbh  at each time.

thanks a lot for help ;-)
Have a good day.