Archives of the TeradataForum

Message Posted: Thu, 17 Jul 2003 @ 20:10:21 GMT

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

Jon is correct. (Note that Teradata Administrator does not allow you to grant Index rights at the database level)

If you do have to grant at the table level use Help Database (or a select statement is better) to create a file containing the table names. Then use SQL Assistant, in Import mode, to run the query:

Grant Index on TheDatabase.? to TheUser

When it asks for the import file point it to your list of tables and it will issue all the grants for you.

If the tables are in different databases create a file containing 2 columns of data (separated by a tab, by default) for Databasename and Tablename and use the Query:

Grant Index on ?.? to TheUser

Similar permutations if you want to issue the grants for more than one user etc.

Import is NOT just for Insert commands. You can issue any SQL statement with an import file. '(Create User' is a useful one when you add a new project to the DBS.)

Mike Dempsey
Teradata Client Tools

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