Archives of the TeradataForum

Message Posted: Wed, 08 Sep 2004 @ 10:29:29 GMT

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

Vijay

Here is the syntax that you need to run to grant access.

     Grant SELECT on DBTest to DBTest_V WITH GRANT OPTION;

This will provide select privileges to all who have permission to access the DBTest_V database. When you create a database that has views, you need to give the data SELECT WITH GRANT OPTION on the tables that the views access. Users only need access to the views and not the tables.

Best Regards

Chris Coffing
AFKS O&M Lead Teradata DBA
Certified Teradata Master

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