Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 12 Jul 2013 @ 21:51:08 GMT


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


Subj:   3610 QueryBanding in View for security check
 
From:   Proulx, Michelle

We have started to use the QueryBand feature within a view as describe in http://developer.teradata.com/applications/reference/using-teradata- query-banding-to-handle-security-views. We've had some success using it from Business Objects Enterprise- WeBI product.

However we had a couple of users access the view without passing QueryBanding values. This resulted in a 3610 error.

     'Internal error: Please do not resubmit the last request. Subcode,CrashCode: 0, 3701'

I do have an incident open with Teradata.

Has anybody else seen this?

So far, The only way I can think of avoiding missing QueryBand Value for "ClientUser" is to define it in the Create User Statement . This would allow a default value for the logged in user.

The view is:

     REPLACE VIEW testviews.BOSupervisorWorkerDimV
        ( WorkerKey ,WorkerID ,WorkerName ,SupervisorID ,SupervisorName ,CountyNbr
              ,CountyName ,ServicingAgencyCode ,ServicingAgencyName ,BOSupervisorID
        )
     AS
     SELECT
     WorkerKey
     ,WorkerID
     ,WorkerName
     ,SupervisorID
     ,SupervisorName
     ,CountyNbr
     ,CountyName
     ,ServicingAgencyCode
     ,ServicingAgencyName
     ,BOSupervisorID

     FROM testviews.BOWorkerDimV

     WHERE ServicingAgencyCode IN (SELECT ServicingAgencyCode
                                      FROM testviews.BOWorkerDimV
                                      WHERE BOSupervisorID = GetQueryBandValue(0,'ClientUser')
                                  )
     ;

MICHELLE PROULX | DATA WAREHOUSE , SYSTEMS ARCHITECT



     
  <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