Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 29 Sep 2005 @ 20:03:27 GMT

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

Subj:   Re: Is it possible to have Show/Help access to a table without having Select to the data?
From:   Anomy Anom

<-- Anonymously Posted: Thursday, September 29, 2005 15:50 -->

Yes. All a user needs to perform a SHOW TABLE is some/any privilege on the database that table is in. We usually grant EXEC to all users. Since there are no Macros in the database they can't do any damage but they are able to Show 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: 23 Jun 2019