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


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.



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: 24 Jul 2020