Archives of the TeradataForum

Message Posted: Thu, 29 Jun 2000 @ 21:44:38 GMT

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

In Teradata, you can use the "ALL" modifier to GRANT rights to any Database / User and all its current and future descendants (children, grandchildren, etc.). Rows are inserted to AccessRights for current descendants at the time of the GRANT, and will automatically be inserted as part of the CREATE DATABASE / CREATE USER process for any new descendants.

So "GRANT TO PUBLIC" is a special case, handled as "GRANT TO ALL DBC".

select * from DBC.AllRights where UserName = 'DBC' and AllnessFlag = 'Y';

As a footnote, be aware that rearranging the hierarchy (i.e. GIVE) does not change AccessRights.

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