Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 06 Apr 2015 @ 12:25:22 GMT


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


Subj:   Re: Avoiding Deadlock on dbc.userrights
 
From:   Dave Wellman

Hi,

Sorry, but I don't think your question really makes any sense.

There is no table called 'dbc.userrights', this is a view. This view joins tables, so it cannot be the target of an UPDATE statement.

Given the above, the only access to this view would be for access rights checking of your UPDATE against a table - an 'express request'. In this process the dbms will only read the underlying data - and I don't believe it does it using this view.


Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)



     
  <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: 23 Jun 2019