Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 29 Aug 2002 @ 21:10:04 GMT

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

Subj:   Re: Grant to ALL user
From:   Anantaraman, Kumaran (K.)

This is what I think Teradata does.

When I login as user zzz and do

grant some_right to ALL xxx;

it adds a row with userid=xxx and allnessflag=y, grantor=zzz.

Later, when user hhh adds a new db or user yyy, with yyy under xxx hierarchy, then during the yyy user creation process, the dbc.allrights table/view is checked to see is *any* of yyy's parents has a right with allnessflag of y, and if such a row exists, in our case xxx row, then that row's rights will be conferred as a right on new user yyy, by inserting a new row in allrights, with grantor as zzz, not hhh or xxx, and allnessflag=n.

Anybody can confirm this??

Kumaran Anantaraman

  <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: 28 Jun 2020