Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 08 Sep 2004 @ 10:28:40 GMT


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


Subj:   Re: Error 3523: An owner referenced by user does not have SELECT WITH GRANT OPTION
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, September 08, 2004 06:24 -->

Your view/view database needs authority.

GRANT SELECT ON TABLE_DATABASE TO VIEW_DATABASE WITH GRANT OPTION;


--------------------------------------------------------
From the Teradata Messages Manual:

3523 %FSTR does not have %VSTR access to %DBID.%TVMID.

Explanation: The user does not have the proper access rights to execute this request, or the owner of the requested view or macro does not have the proper access rights to underlying tables.

Generated By: SQL modules.

For Whom: End User.

Remedy: Obtain the necessary access rights.



     
  <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