Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 16 Feb 2001 @ 19:06:03 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Qualifying on encrypted passwordstring
 
From:   Leszek Kosinski

I am trying to use database security on a web application which sends queries to Teradata.

When a user logs on to the web application, he types his Teradata user and password. Then application logs on to the database (with an access level to system tables) in order to check whether his username and password is correct. Since password is encrypted, is it possible to apply an encrypt/decrypt function to a "where" clause and qualify on passwordstring attribute?

example:

select username
from dbc.dbase
where
username = #username // variable from the interface
and passwordstring = ENCRYPT(#password) //variable from the interface


Thank you,

Leszek



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016