Archives of the TeradataForum

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

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

<-- 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>>