Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 24 Jun 2002 @ 20:56:48 GMT

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

Subj:   Re: Archive accessrights
From:   Joanne Schultz

If you look at the dbc.accessrights table, you'll see that it keeps track of everything by internal id. If you do a grant at a database level that information is kept by database id. If you do a grant at the table level that information is kept by table id.

If you have the same database ids as before, then the accessrights that were granted on databases are still valid. But if you create new tables by using "copy" instead of "restore", then you lose grants that were done on those specific tables.

  <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: 27 Dec 2016