Re: select connect in a PL/SQL routine
Date: Wed, 05 Jun 2002 14:14:29 GMT
Message-ID: <91pL8.116008$ux5.175252_at_rwcrnsc51.ops.asp.att.net>
You cannot. Why? The password is encrypted and so you cannot compare the
username and password. Oracle, for security reasons, does not provide a
mechanism to unencrypt the password. I haven't done this, but in the
documentation you can write a routine that prevents people from creating a
password that is the same as their username.
Jim
"Fleury Marcel" <marcel.fleury_at_bluewin.ch> wrote in message
news:f18358b2.0206050458.1cab8c2c_at_posting.google.com...
> Hello,
> From sqplus I use the following command to display all accounts that
> use the same string for the username and password :
>
> SQL> select 'connect '||username||'/'||username from all_users;
>
> 'CONNECT'||USERNAME||'/'||USERNAME
> ---------------------------------------------------------------------
> connect SYS/SYS
>
> But I would like to use this command into a PL/SQL routine.
> How can I do it ?
>
> Tnak you
Received on Wed Jun 05 2002 - 16:14:29 CEST