Archives of the TeradataForum

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

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

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>>