Re: How to check valid user/pwd in stored procedure ???

You probably can't; the password is inaccessible except in encrypted form so the function would need to encrypt the input variable in the same way...

Saverio Tirone <saverio.tirone_at_semagroup.it> wrote:

>In a PL/SQL stored procedure I need to validate a login and password
>(same RDBMS) .
>Is there any funcion to do that ? If not, how can I write this function
>??
>The function valid_user(login varchar2,pwd varchar2) shoud return a
>true/false value.
>
>Thank you in advance for your help
>
>
>

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Fri Jan 21 2000 - 09:06:20 CST