Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 07 Aug 2015 @ 17:35:37 GMT

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

Subj:   Re: Read Access on System Level to a User
From:   Walter, Todd

That's what I get for reading quickly on my phone... I read it as the other part of the problem - assign to all users. Thanx Dave for catching that!

This request is even easier.

If you want to grant a right to all the objects in the database, simply grant at the database level.

     GRANT SELECT ON databasename to user;

Will give select on all tables and views in that database to that user.

A less known capability (and poorly documented) is that if you have a hierarchy of databases defined, then do the grant to the root database of that hierarchy, it will be propagated to all the databases below that one in the hierarchy.

Assuming database x has a child database y:

     GRANT SELECT ON x to u;

Will give u SELECT access to y as well.

  <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: 24 Jul 2020