Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 17 Sep 2001 @ 18:14:50 GMT


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


Subj:   Lost use of some PC tools
 
From:   Tony Howe

Here's my situation. I have a database where all my Views/Macros for all tables are stored (database=VMDB) We used to allow SELECT access to all views/macors in this database. (GRANT SELECT ON VMDB TO PUBLIC) This turned out to be the wrong thing to do. So now we GRANT SELECT ON VMDB.view/macro_name TO userid; But in doing this, there "PC Tools" have stopped working, the point and click stuff, it say they do not have SELECT access to VMDB. Queryman is one of them along with MS Access, SAS Query etc.

How can I GRANT where they can still use there tools but only have access to the views/macro's they are allowed??

Thanks, Tony.



     
  <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