Archives of the TeradataForum
Message Posted: Thu, 29 Aug 2002 @ 21:10:04 GMT
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??
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|