Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: PUBLIC's Rights
From:   Fred Pluebell

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023