All Forums Database
sankumar0506 1 post Joined 04/15
25 Jun 2015
SQL Script To Grant Select on All Views Within a Database

I have a need where i need grant Select on all Views in the database
 
Thanks in Advance
 
 

dnoeth 4628 posts Joined 11/04
27 Jun 2015

If you follow Teradata's recommendations to seperate tables and views into different databases, it's a simple GRANT SELECT ON myDb TO myUser;
Otherwise create the GRANT statements FROM dbc.TablesV WHERE TableKind = 'V'

Dieter

You must sign in to leave a comment.