Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 05 Jun 2005 @ 09:58:40 GMT


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


Subj:   Re: Grant option in DB
 
From:   Harizanov, Ivan

I think the best why of explaining this is with an example.

Say you have DB1 & DB2 and you want to create view in DB2 which view references the base table in DB1. In order this to work than DB2 must have with grant option on DB1.

The same philosophy applies if you have stored procedures, triggers or macros, every time when references is made to the object which lives in another database than access is required between databases.

The usual error message which comes in above case is quite misleading.

Hope the above shed some light.


IvanH



     
  <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