Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 13 Jan 2003 @ 21:52:29 GMT


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


Subj:   Re: Data selection
 
From:   Jim Downey

I have a metadata table that I want to limit who has access based on their userid. The following code is embedded in a macro (it could be a view) and only returns rows where the metadata status of the row exceeds the minimum value that the user is allowed to see. (Business users can only see high value metadata while systems users might want to see all of it). The users with 'special' privileges are kept in a table named Metadata_Users. Rather than maintain ALL user ids, our web application defaults to logging on with a generic userid (Metadata_guest). If the user id is not found, the sub-query returns the value associated with the generic id.... Actually it returns the min value which works for me but you would want to validate it works for what you want to accomplish.

AND Metadata_Status_In >=
(
SEL MIN(READ_Metadata_Status_In) AS Metadata_Status_In
FROM METADATA.METADATA_USERS
WHERE METADATA_USERID IN (USER,'METADATA_GUEST')
)

I hope this helps.

Jim



     
  <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