Archives of the TeradataForum

Message Posted: Thu, 17 Jul 2003 @ 15:49:56 GMT

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

You need Drop Table access to run collect statistics not Index. Index and Reference are 'ungrantable' access rights that appear in the allrights table once a user who has drop table access issues an Index or Reference command.

grant (drop) table on database to user;

Ian

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