Archives of the TeradataForum

Message Posted: Fri, 07 Dec 2007 @ 14:49:22 GMT

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

Victor here is a practical example, I think it will answer your question.

     create table tempdb.ebtest1
     ( x1 integer,
     x2 integer
     ) primary index xpk1(x1);

     grant index on  tempdb.ebtest1 to < accountname >;

     select * from dbc.allrights
     where tablename = 'ebtest1'
     and databasename = 'tempdb';

The accessright to look for is 'IX'

The inividual account will have this access right.

It is in the Data Dictionary Manual, under AccessRights.

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