Archives of the TeradataForum

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

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

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