Archives of the TeradataForum

Message Posted: Thu, 17 Jul 2003 @ 19:59:56 GMT

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

The INDEX right cannot be granted at the database level. Only at the object level. So I guess you'll have to grant DROP TABLE at the database level to the user who's going to be collecting stats. You can collect stats if you have the DROP TABLE right.

If you really, really need to grant INDEX instead, you can write a query that will generate all the GRANT INDEX... statements. Then .export report the query and .run the resulting file. It's a useful technique.

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