SQL Script To Grant Select on All Views Within a Database

Database

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

Tags (1)
1 REPLY
Junior Contributor

Re: SQL Script To Grant Select on All Views Within a Database

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'