Re: SQL CLI user validation

The SQL statements will always run on the local box, we aren't doing
anything with remote servers.  I thought that since the db is on the
iSeries, and the program is running there too, there was some sort of
"inline" authorization method.  I don't want the user to type in their
password (they will already be signed on), and I don't want to store
passwords.

On 6/18/05, Carel Teijgeler <coteijgeler@xxxxxxxxx> wrote:
> Tony,
> 
> I think the user with whom you want to establish the connection, must be a
> valid user on the (remote) system.
> 
> I would take a look at validation lists In those lists you might store the
> user IDs and their password.
> I have not use them myself, yet, but I am working on a similar "project".
> 
> Just my thoughts on the problem.
> 
> Regards,
> Carel Teijgeler
> 
> *********** REPLY SEPARATOR  ***********
> 
> On 17-6-05 at 18:14 Tony Carolla wrote:
> 
> >I have started using SQL CLI, and I have a question. When establishing a 
> >connection, user name and password are required. Now, I know how to get the
> 
> >current user name, but is there any way to 1) Get the current password 
> >(doubt it), or 2) somehow establish a connection using the current user
> that  is running the program? 
> 
> 
> 
> -- 
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
> 
>