Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 20 Apr 2009 @ 20:47:57 GMT


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


Subj:   An owner referenced by user does not have index with grant option
 
From:   Anomy Anom

<-- Anonymously Posted: Monday, April 20, 2009 16:26 -->

Hi b

I am getting this error below.

An owner referenced by user does not have index with grant option b


Please note Index

To resolve this when I execute this:

     GRANT INDEX ON table_DB TO view_db WITH GRANT OPTION;

I get an error:

     Error Code 3706:  Syntax error: Attempt to grant/revoke INDEX on database object.

Even Winddi does not allow checking the index option. It seems we cannot grant index level right at database level. Any ideas how can we get this resolved ?


Thanks -



     
  <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