Archives of the TeradataForum

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

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

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>>