<p>Assuming such a query exists, I would greatly appreciate the help.</p>

<p>I'm trying to develop a permissions script that will grant "select" and "references" permissions on the user tables and views in a database.  My hope is that executing the "grant" commands on each element in such a set will make it easier to keep permissions current when new tables and views are added to the database.</p>

```
```
select * from information_schema.tables
where table_type = 'view'
```
```