Grant select on tables with a specific naming pattern How to grant select on all tables starting with VVC_? 

grant select on VVC_* to user1
There is no inbuilt method for granting permissions on tables matching a pattern. You need to grant it to the individual tables.

It would be quite easy to generate the required script with a query against sys.tables for names like 'VVC[_]%' though.

Instead of using a VVC prefix you could create a VVC schema. Then you can grant select permissions on the schema. This would also cater for tables added in the future to the same schema.