Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: GRANT at database level..
 
From:   Dempsey, Mike

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023