Grant select on all views and tables to user in Oracle

​To grant select on all views to  user, execute the query as follows

Query:

"select 'grant select on '||view_name||' to <user_name>;' from user_views"

 

To grant select on all tables to user, execute the query as follows

Query:

"select 'grant select on '||table_name||' to <user_name>;' from user_tables"

​