Archives of the TeradataForum
Message Posted: Thu, 29 Jun 2000 @ 21:44:38 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|